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 FilesIBMSQLLIBBIN>db2 restore db CTHIS from C: taken at 201702091
64335 into CTHIS
SQL0968C 文件系统已满。 SQLSTATE=57011

C:Program FilesIBMSQLLIBBIN>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