Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2007
    Posts
    4

    Unanswered: SQL1271w after rolling forward

    Hi all dbforums...

    we used log retain in DB2 for backup recovery to other side datacenter and every close system. we backup database with rolling forward.

    i have a problem with condition :
    every close system we always doing rolling forward with "rolling forward database ******** " to end of logs and complete ".
    and for the first time we have a reason from DB2 7.2 with message error like this "SQL1271W Database "*****" is recovered but one or more table spaces
    are off-line on node(s) "0".".

    please i need a help to solving this condition

  2. #2
    Join Date
    Jan 2008
    Posts
    88
    do a db2 list tablespaces show detail for tha database

    den see the status of the tablespaces...if its offline den check the filesystem (where the tablespace is created) is available or not.

    If not do a tablespace level restore of the database and rollforward it...

    if it doesnt work do a redirected restore and create the tablespace again

    also, what version u r workin on and what is in th diag log

Posting Permissions

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