db2 backup export

备份命令:

db2 backup db test to /db2data/

监控备份进度:

db2 list utilities show detail

Estimated Percentage Complete = 51 <-进度

检测备份文件的有效性:

db2ckbkp /db2data/TEST.0.db2inst1.NODE0000.CATN0000.20171017225437.001 

执行恢复操作

db2 restore db TEST from /home taken at 20171017225437 into test

SQL2523W  Warning!  Restoring to an existing database that is different from 
the database on the backup image, but have matching names. The target database 
will be overwritten by the backup version.  The Roll-forward recovery logs 
associated with the target database will be deleted.
Do you want to continue ? (y/n) y

监控恢复进度:

db2 list utilities show detail

此外可用db2pd命令:

 db2pd -utilities

 

posted @ 2018-07-04 10:57  jiayou64  阅读(241)  评论(0编辑  收藏  举报