Results 1 to 11 of 11
  1. #1
    Join Date
    Aug 2010
    Posts
    43

    Unanswered: db2, wichs logs I need in a rollforward to end of logs?

    Hello, I need your help

    How many logs I need for rollfordward database?

    I execute rollforward an proccess 87 logs, but I didn't have the next log!!!! S000400.LOG

    Could you help me please?

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    At a minimum you will need the logs that were active during the online backup. But the exact number of logs needed depends on whether you roll forward to:

    1. end of logs,
    2. a specific time, or
    3. minimum roll forward time (END OF BACKUP).

    You can also try the NORETRIEVE option, which sometimes limits the number of logs that will be required.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Aug 2010
    Posts
    43
    Thaks Marcus A,

    I execute db2 "rollforward db <db name> to end of logs and stop overflow log path (<dir where you copied the logs>) noretrieve"

    Then... I will need the logs that were active during the online backup?
    but....I had a backup from 20080514, and my last log 20080516!!!, I will try one more time with other backup that I have more LOGS...7 days.

    What do yo thing?

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Do you need to rollforward to end of logs, or do you just need to restore the backup and rollforward the logs to the end of backup? If the later is true (and you have DB2 9.5+) then rollforward to END OF BACKUP.

    If you don't have a DB2 version that supports END OF BACKUP option, then rollforward to 2000-01-01.01.01.01.000000 and DB2 will give you an error telling you the minimum rollforward time, and then resubmit the rollforward with the minimum rollforward time that DB2 tells you.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  5. #5
    Join Date
    Aug 2010
    Posts
    43
    I only need connecto to my db
    I just need execute rollfordwar to any time...only finish and connect

    I will try with your advice

  6. #6
    Join Date
    Aug 2010
    Posts
    43
    What do you thing?
    What is the correct command?

  7. #7
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Rollforward to END OF BACKUP AND STOP as described above.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  8. #8
    Join Date
    Aug 2010
    Posts
    43
    ohhh no, my version don't accept to end of backup, I have 8.2 version.

    I will try with end of logs again, but now I have more LOGS.

    Thaks Marcus...I will tell you when finish.
    Maybe I will need your help again.

  9. #9
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by hozkr hozoryo View Post
    ohhh no, my version don't accept to end of backup, I have 8.2 version.

    I will try with end of logs again, but now I have more LOGS.

    Thaks Marcus...I will tell you when finish.
    Maybe I will need your help again.
    I gave you the alternative to use if you can't use END OF BACKUP. Read my post above.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  10. #10
    Join Date
    Aug 2010
    Posts
    43
    I tried whit your other suggestion, but when I execute rollforward to <date>, return me that other parameter was espected.

    what problems could I have with end of logs? I hava more LOGS.
    attempt to reach the current date?

    When give me the error, that the last logs not found I can try with other parameters?
    Coul yo give the correct sintax?

    thank

  11. #11
    Join Date
    Aug 2010
    Posts
    43
    Marcus Thanks for your help
    I appreciate it!!!

    I restored my db.
    If you need anything and if I can help you, only ask.

Posting Permissions

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