db2备份与还原
备份db2stop forcedb2startdb2 backup db dbname to /home/db2inst1/off_back
还原
db2 restore db dbname from /home/db2inst1/on_back taken at 20070608
如果运行backup命令时报错
SQL1035NThe database is currently in use.SQLSTATE=57019
可以输入db2 force application all,这样就停止了DB2
然后输入 db2start启动db2 重新做备份
页:
[1]