var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Restore not working.
Two machines both Win XP and the very same level of db2 'DB2 v220.127.116.11'
Backed up the BUSCONT database from one that works fine and want to put it on the other machine but keep getting this:
C:\TMP>DB2 RESTORE DATABASE BUSCONT into BUSCONT
SQL0902C A system error (reason code = "") occurred. Subsequent SQL
statements cannot be processed. SQLSTATE=58005
Please help. I'm pulling my hair out on this one.
Your restore command is incomplete. DB2 needs to know what to restore. It needs to know where the image is located and which image to restore.
The restore command is fine. I'm doing it from the location where the backup is. The back and the new db names are both the same.
If the above restore command is the complete command you are issuing, then it is not fine. It does not tell DB2 where the image is located, nor does it tell it which image to restore.
try the following command:
DB2 RESTORE DATABASE BUSCONT on c: dbpath on c:
That still will not work. The OP still needs to tell the restore command where the image (USE, LOAD, FROM) and which image to restore (TAKEN AT). I was hoping that the OP would RTFM and learn it themselves instead of having it spelled out.
You don't need to tell the location/timestamp of the image if the restore command is issued from the dir where the image is located and there is only one image for this db.
Restore was complaining about D: being unavailable and this is most likely due to the source db/tablespaces having its automatic storage on D: