Recently entered a new project, using the database is DB2, encountered some problems of egg pain, fortunately, all solved. nn ... Now the record is the first import data source problem, the project inside the vanguard to give me a backup of his data source (yes, is backed up, not to come out, why give a backup of the data source is not to give out, others give reason is backup out than export to save time,), Is such a file (uibs.0.db2.node0000.catn0000.20150715091129.001). Then there is no way to put this file under (C:\Tools), then built a uibs library, and then open db2cmd, typing command: DB2 restore DATABASE uibs from "C:\Tools" taken at 20150715091129, unfortunately, it's an error.
Then went online to check the error number and solution, the command changed to: DB2 Restore DATABASE uibs from "C:\Tools" taken at 20150715091129 on C: \ DBPath on D:\DB2, so the safe passage of 。 After the class is rolled forward, the command is typed: DB2 Rollforward DB uibs to end of logs and stop, cannot roll forward. So it is a network search solution, the order changed to: DB2 Rollforward DATABASE Uibs to END of the LOGS OVERFLOW LOG PATH ("C:\Tools\log"), hehe or error. The contents of the log file is insufficient, I am aware that the delivery of the document is not complete. So from his copy of the missing log file, and then execute the above command, finally can.
The end is the user's problem. Because I don't have a Windows user for the database user group, there's no way to build a db2inst1 Windows user. Finally, it can be used.
Build a library with B2 backed up files