Results 1 to 8 of 8
  1. #1
    Join Date
    Dec 2007
    Posts
    11

    Unanswered: Recovery without Log files

    Hi,
    I am having only 2 days online backup image. I have no log files with me. I am able to restore the Database with the backup image. How to bring the database up from rollforward pending state since I am not having any log file?
    To be more precise, is ity possible to bring the database up from online backup image without log file,If so How?
    Thanks

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    What DB2 version and OS are you using?

    Andy

  3. #3
    Join Date
    Dec 2007
    Posts
    11
    Version is 8.1.0.136 Fixpack 15
    o/s Unix

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Do you use the INCLUDE LOGS clause in the backup command?

    Andy

  5. #5
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Use the WITHOUT ROLLING FORWARD option (see manual) to prevent the rollforward-pending state.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  6. #6
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Quote Originally Posted by stolze
    Use the WITHOUT ROLLING FORWARD option (see manual) to prevent the rollforward-pending state.
    Stolze,

    This is an ONLINE backup you cannot use WITHOUT ROLLING FORWARD clause in this case. From the manual:

    WITHOUT ROLLING FORWARD
    Specifies that the database is not to be put in rollforward pending state after it has been successfully restored.

    If, following a successful restore operation, the database is in rollforward pending state, the ROLLFORWARD command must be invoked before the database can be used again.

    1 If this option is specified when restoring from an online backup image, error 1 SQL2537N will be returned.


    Andy

  7. #7
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Right. I skimmed too fast over the post and didn't notice that it was an online backup.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  8. #8
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    There are two options:

    1. Call IBM support and beg them to help you (they "can" overrirde the rollforward pending flag if you convince them that data integrity issues will not be a problem and you will not sue them if you database is out of synch with uncommited data), or

    2. Update your resume.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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