Db2 restore restoration Database "cannot connect or activate Database"

When you use the restore command to restore a database, the command line shows that the database is restored successfully,

 

C: Documents and SettingsAdministrator> db2 restore database XXX from "D: DB2"

Taken at 20110515133036 on "d:" dbpath on "D: DB2" into XXX comprlib D: DB2

Db2compr. dll

SQL1035N is currently using a database. SQLSTATE = 57019

 

C: Documents and SettingsAdministrator> db2 restore database XXX from "D: DB2"

Taken at 20110515133036 on "d:" dbpath on "D: DB2" into XXX comprlib D: DB2

Db2compr. dll

SQL2529W warning! Restore to an existing database that is different from the backup image database, and the alias of the existing database

"YYY" does not match the backup image alias "XXX" and the database name of the existing database "XXX"

Name of the database with the backup image "XXX"

Does not match. The target database will be overwritten by the backup version. The Rollback Recovery logs associated with the target database will be deleted.

Do you want to continue? (Y/n) y

The DB20000I restore database command is successfully completed.

Use the connect command to connect to the database. The following error message is displayed:

SQL1117N cannot connect to or activate the Database "XXX" due to ROLL-forward pending ".

SQLSTATE = 57019

 

The Database "XXX" has been earlier than or equal to "2011-05-23-07.06.38.000000 UTC"

The node cannot be out of the roll-out and hold state, because "0" contains information updated at a specified time.

Find information online and run the rollforward command:

 

 

 

 

Reference: http://bpmfhu.itpub.net/category/47/124

 

After running, the following prompt is displayed, indicating that the operation is successful and the database is connected again, indicating that the connection is successful.

 

Roll-forward status

 

Input Database alias = XXX

Number of nodes returned status = 1

 

Node number = 0

Roll Forward status = not suspended

Next log file to be read =

Processed log files =-

Last implemented transaction = 2011-05-23-07.25.15.000000 UTC

 

The DB20000I ROLLFORWARD command is successfully completed.

Db2 rollforward db XXX stop