Database is in Roll forward pending state

[spaduchuri]

Hello All,

I have restored a database from backup. I've tried to do roll forward to the end of the logs from the Control center. The job says succeded but the database is still in roll forward pending state.

If I use the command line processor and I issue

rollforward database database-name to end of the logs, I get an error
An unexpected system error occured. SQL State 58004
If I try to do a roll forward to a particular time. It gives me an error saying
SQL1274N The database database-name requires a roll forward recovery and the point in time must be to the end of the logs.

Can some body help me out please. Thanks, for your help in advance.

Sudheer

 

[dbmsguy]

have you done a roll-forward compete?? ie the command. Paul

http://www.dbmsguy.com

 

[2742]

DO THE COMMAND ON A COMMAND WINDOW TRY SOME OF THE FOLLOWING:

DB2 ROLLFORWARD DATABASE DBNAME TO END OF LOGS AND STOP (THIS IS THE ONE I USE)
OTHER OPTIONS INCLUDE:
DB2 ROLLFORWARD DATABASE DBNAME COMPLETE
DB2 ROLLFORWARD DATABASE DBNAME TO END OF LOGS AND COMPLETE

HOPE THIS HELPS