Results 1 to 6 of 6
  1. #1
    Join Date
    Jul 2007
    Posts
    4

    Smile Unanswered: SQL1272N Table space level roll-forward recovery for database "SID" has stopped befo

    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
    Last edited by pravinkpatil; 07-11-07 at 17:43. Reason: adding more details

  2. #2
    Join Date
    Jul 2007
    Posts
    6
    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

  3. #3
    Join Date
    Jul 2007
    Posts
    4

    Red face

    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.

  4. #4
    Join Date
    Sep 2003
    Posts
    237
    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.
    mota

  5. #5
    Join Date
    Jun 2007
    Posts
    12
    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..

  6. #6
    Join Date
    Sep 2003
    Posts
    237
    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
    mota

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •