Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2008
    Toronto, Canada

    Unanswered: db2 z/os - recover to RBA

    db2 v10 on z/OS

    Let's say I want to recover a tablespace using an image copy taken at 6am this morning and then apply the logs up to 11am. I use TORBA option to perform recovery, but I don't know the RBA of 11am. There was no QUIESCE performed for any tablespace between 6am and 11am. Is there some way to convert "11am timestamp" to RBA? How can I perform PIT recovery without knowing the RBA?

  2. #2
    Join Date
    Oct 2007
    Provided Answers: 9
    did you have checkpoint(should be occurring every 10 minutes) or archive log at close to 11? Also, do you have a log analysis tool? You could just undo what was done since 11.

    Dave Nance

Posting Permissions

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