Unanswered: restoring the admin DB after a restore of DB.
We have a system on db2 7.2 / AIX 5.1 for SAP 4.6C database
We have just restored our database from our TSM backup.
The current state is:
Input database alias = EP1
Number of nodes have returned status = 1
Node number = 0
Rollforward status = DB pending
Next log file to be read = S0034826.LOG
Log files processed = -
Last committed transaction = 2004-07-07-17.00.16.000000
My instructions say to rebuild the adminDB from the adminDB.xxxx.SAR file which i have extracted into a temp directory so that we may "brrestore" (extract the logs from tape) the logs files required for roll forward.
when i do a db2 connect, the following error occurs:
SQL1117N A connection to or activation of database "EP1" cannot be made
because of ROLL-FORWARD PENDING. SQLSTATE=57019
When rebuilding the adminDB from this command "sddb6ins -i", it finishes okay, but in the steps, the same step error occurs:
"A connection to or activation of database "EP1" cannot be made
because of ROLL-FORWARD PENDING."
When applying this command:
db2move ADMEP1 IMPORT -io INSERT_UPDATE
i get these errors:
***** DB2MOVE *****
In Summary, we want to roll forward after the restore, but its in a pending state and the Admin DB cannot be created because of this. But we need the adminDB to be restore as it contains the logs information we need to extract it from tape to allow us to roll forward.