db2数据备份与恢复

备份：先关掉所有tomcat
运行：db2cmd

db2Stop force
db2Start
DB2 FORCE APPLICATIONS ALL
DB2 BACKUP DATABASE histest TO D:\数据库备份

db2 Create db HISTEST on D:
db2 restore db HISTEST from D:\数据库备份 taken at 20170209164335 into HISTEST
db2 rollforward db HISTEST to end of logs and stop

 

虚拟机数据库恢复出现的问题
SQL0968C 文件系统已满。 SQLSTATE=57011

C:\Program Files\IBM\SQLLIB\BIN>db2 restore db CTHIS from C: taken at 201702091
64335 into CTHIS
SQL0968C 文件系统已满。 SQLSTATE=57011

C:\Program Files\IBM\SQLLIB\BIN>db2 restore database CTHIS from C: taken at 201
70209164335 on "C:" into CTHIS
DB20000I RESTORE DATABASE 命令成功完成。

  DB2JAVIT：RC=9505

我的电脑--》管理--》本地用户组 做如下操作，重启电脑即可

 

转载于:https://www.cnblogs.com/jwlfpzj/p/6691773.html