日期:2014-05-16  浏览次数:20554 次

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))";