Restored database not cataloging

[martynh]

Using DB2 8.2 on RHEL 3, I created a test database, put some test data in it and did an online backup specifying 'include logs'. The backup was fine and I managed to do a restore and rollforward with it.

I then dropped the database and tested restoring from the backup file, which I had kept. The command seemed to complete successfully, but the database was not cataloged. Also, I can not manually catalog the database (if I do, then it's as if the database is not there).

Any suggestions anyone?

Martyn Hodgson

 

[rbod]

UNcatalog the database and then catalog it again.
If that doesn't do it, try db2stop and db2start [if possible].