db2 数据备份和还原
connect toodsdb user reportdbusing reportdbconnect torspdb1 user rspdbusing rspdb1
connect torspdb user rspusing rsp
db2 connect to cognosdb user db2admin using db2admin
connect to wasdb user db2admin using db2admin
db2 backup database cognosdb user db2admin using db2adminto e:\db2\backup
db2 catalog tcpip node rspdb remote 192.188.1.153 server 50003
db2 catalog database rspdb as rspdb at node rspdb
db2 catalog tcpip node rspdb1 remote 192.188.1.242 server 50002
db2 catalog database rspdb as rspdb1 at node rspdb1
db2 conncet to rspdb user rsp using rsp 生产
db2 conncet to rspdb1 user rspdbusing rspdb1 测试
db2 conncet to cognosdb user db2admin using db2admin 本地
db2 catalog tcpip node rspdb2 remote localhost server 50001
db2 catalog database cognosdb as cognosdb at node rspdb2
db2 catalog tcpip node rspdb3 remote localhost server 50001
db2 catalog database wasdb as wasdb at node rspdb3
db2 list db directory
数据迁移方法
export脚本示例 db2 connect to testdb user test password test
db2 "export to aa1.ixf of ixf select * from table1"
db2 "export to aa2.ixf of ixf select * from table2"
db2 connect reset
import脚本示例 db2 connect to testdb user test password test
db2 "load from aa1.ixf of ixf replace into table1 COPY NO without prompting "
db2 "load from aa2.ixf of ixf replace into table2 COPY NO without prompting "
db2 connect reset
export脚本示例 db2 connect to rspdb user rsp using rsp
db2 "export to aa1.ixf of ixf select * from APP_HELP_INFO"
db2 "export to aa2.ixf of ixf select * from table2"
db2 connect reset
import脚本示例 db2 connect to cognosdb user db2admin using db2admin
db2 "load from aa1.ixf of ixf replace into APP_HELP_INFO COPY NO without prompting"
db2 "load from aa2.ixf of ixf replace into table2 COPY NO without prompting "
db2 connect reset
export to c：/aa.ixfselect * from sys_app_info
export to 'C:\sys_app_info.del' of del select * from sys_app_info
importfromc：/aa.ixf
import from 'C:\sys_app_info.del' of del insert into sys_app_info;
db2look -d cognosdb -e -o ddlfile -i db2admin -w db2admin
db2move cognosdb export -u db2admin -p db2admin
db2 connect toodsdb user reportdbusing reportdb
db2 backup database odsdbuser reportdbusing reportdb to e:\db2\backup
db2 connect towasdb user db2adminusing db2admin
db2 backup database wasdb user db2adminusing db2admin to e:\db2\backup
直接使用db2 backup db的命令，就可以完成你的需求，
如果系统出现问题，需要创建INSTANCE用户，再创建INSTANCE，再恢复DB
整个库的信息就全部恢复回来了。
db2 restore db bqry from d:\backup into btst
页:
[1]