备份:先关掉所有tomcat 运行:db2cmd
db2Stop forcedb2StartDB2 FORCE APPLICATIONS ALLDB2 BACKUP DATABASE histest TO D:\数据库备份db2 Create db HISTEST on D:db2 restore db HISTEST from D:\数据库备份 taken at 20170209164335 into HISTESTdb2 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 20170209164335 into CTHISSQL0968C 文件系统已满。 SQLSTATE=57011C:\Program Files\IBM\SQLLIB\BIN>db2 restore database CTHIS from C: taken at 20170209164335 on "C:" into CTHISDB20000I RESTORE DATABASE 命令成功完成。
DB2JAVIT:RC=9505
我的电脑--》管理--》本地用户组 做如下操作,重启电脑即可