2016-4-28

• DB2 Single-table backup
• --Create a table of the same structure

• DB2 = Create

Table TableName as (SELECT * from tblname) definition only

• --Inserting existing data

• DB2 = insert

Into TableName select * from Tblname

DB2 Import and Export

Export

DB2 Exprot to FileName of FileType select * from TableName

? import

DB2 Import from FileName of FileType insert into tableName (field name)?

Linux SCP Remote Files

Copy the file to the target host?

-SCP url/filename [email protected] (10.113.148.199)?: Url/filename

Copying files from the target host to the native

-SCP [email protected] (ps:10.113.148.199)?: Url/filename Url/filename

?

2016-4-28