This is for DB2 9.7 Enterprise Server Edition on AIX.
I had a full, offline backup taken of several databases within our instance in a performance environment.
I wanted to restore these databases to our integration environment.
I ran the command
db2 restore database database_name from /bkp/instance_name/OfflineBackups/RestorePoint/my_restore_point taken at 20120321103846 into database_name without prompting;
for each of my databases (modifying the database name and timestamp appropriately of course).
Each database restored successfully according to DB2. However, now when I wish to check if the database did indeed restore what I thought, I try to connect to a database and I get the error
SQL1117N A connection to or activation of database "database_name" cannot be made because of ROLL-FORWARD PENDING. SQLSTATE=57019
I didn't have any in process transactions in the previous database because all connections were forced off and the database was down for an offline backup. What do I do?