Hi friends,

Two tablespaces are in "Roll forward pending" Status. We are at V8 (8.2.3)
details of the list tablespaces for these two are as follows :

Tablespace ID = 8
Name = <SID>#tbsp1
Type = Database managed space
Contents = Any data
State = 0x4080
Detailed explanation:
Roll forward pending
Offline

Tablespace ID = 9
Name = <SID>#tbsp2
Type = Database managed space
Contents = Any data
State = 0x4080
Detailed explanation:
Roll forward pending
Offline

I tried to do the Rollforward database with the table space listed
and I kept getting the SQL1272N error. I tried to do the rollforward with
one table space in the list, with both of them, and also with the tablespace
Online option and not specify the tables spaces. No matter how I do it, I
get the SQL1272N.

The syntax I used :

db2 "rollforward db <SID> to end of logs on node (0) and complete tablespace online"

db2 "rollforward db <SID> to end of logs on node (0) and complete tablespace (<SID>#tbspa1)"

db2 "rollforward db <SID> to end of logs on node (0) and complete tablespace (<SID>#tbspa1, <SID>#tbspa2)"

Please help ASAP....

Regards,
Pravin

Dude,

I guess you have been doing a restore from an online backup, or you have done an online backup by changing the parameters LOGRETAIN to RECOVERY and USEREXIT ON. My suggestion is to do an offline backup after you do an online backup and it will work fine.

Hope this helps

Hi,

No I am trying to restore...actually it was a DB2 creash and those two tablespaces went in roll forward pending status ..and was trying to get those to "Normal" status.

I had this problem when there was an IO error with the tablespace; have you corrected that? Ask your OS admin to check into it. What does db2nfy(the admin log )say about the problem.When io is corrected your last command should work.

hey dude,

once u'r tablespaces shows u in rollforward pending state, that means that u had to rollforward..

but u r only trying with END OF LOGS option.....

as u said u'r db2 was crashed, u had to rollforward to specific point of time that is prior to u'r db2 crash.

u can try out like this

db2 "rollforward db <SID> to timestamp using local time and complete on node (0) tablespace (<SID>#tbspa1, <SID>#tbspa2) online"

here the timestamp should be the time prior to u'r db2 crash..

you cannot rollforward a database to a specific point in time, UNLESS you did a restore and rolforward;here, the db crashed; the ONLY option is to rollforward to the end of logs