DB2归档恢复语句
db2 connect to export
db2 get db cfg |more
db2stop force
db2start
db2 backup db export to /home
db2 connect to export
db2 update db cfg for export using LOGARCHMETH1 DISK:/home/exportlog
db2 backup db export to /home
db2 connect to export
db2stop force
db2start
db2 backup db export online to /home include logs;
归档恢复
su - db2inst1
db2 restore db export from /home taken at 20100824154648 logtarget /home/log
db2 "rollforward db export to end of backup and complete overflow log path (/home/log)"
db2 "create table test10 (id varchar(2),name varchar(8))";