- DB2单表备份
- --建立相同结构的表
- db2 => create
table TableName as (select * from TblName) definition only
- --插入原有数据
- db2 => insert
into TableName select * from TblName
DB2导入导出
导出
db2 exprot to fileName of fileType select * from tableName
导入
db2 import from fileName of fileType insert into tableName(字段名)
Linux scp 远程文件
把文件复制到目标主机
-scp Url/fileName userName@address(10.113.148.199):Url/fileName
从目标主机复制文件到本机
-scp userName@address(ps:10.113.148.199):Url/fileName Url/fileName