Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2004
    Posts
    23

    Exclamation Unanswered: Where the information about logs required for the recovery is stored?

    Hi all!

    I am sorry for poor English.

    I while the beginner in DB2 (9 years of experience in Oracle).

    I have DB2 UDB v.8.2 for Win2000.

    Whether somebody can tell me, where IS REAL in DB2 to be stored an information what log files are necessary for RECOVER table spaces!

    I know, that is tablespace change history file (DB2TSCHG.HIS), but as far as I have understood during testing of the scenario on recovering, this file does not play here any role!

    Beforehand I thank for any explanations!

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    By issuing db2 get db cfg for <database name> | find /i "first active log"" you'll learn the first log file since the last backup. Rollforward command may need any log file between that file and the currently active file.

    db2 list history backup all for <database name> will tell you the range of log files created during an online backup. These will also be required for the database recovery.

  3. #3
    Join Date
    Nov 2004
    Posts
    23
    Many thanks, that have responded to my problem!

    You wrote:
    By issuing db2 get db cfg for <database name> | find /i "first active log"" you'll learn the first log file since the last backup.

    As far as I have understood this parameter (loghead) indicates on the
    lowest numbered log that is active and it dynamically is refreshed
    during completion of transactions in a database.

    You wrote:
    Rollforward command may need any log file between that file and the currently active file.

    I am interested in what physical object (included in a structure,
    databases
    ) the information about the current unique identifier
    of the completed transaction, on which DB2, should compare
    with the same identifier at a level of tablespaces
    (me a place the storage too interests it), to determine
    whether is necessary rollforward of transactions on tablespaces to
    recover a database in an consistent state?

    From your answer and as I have understood independently,
    this information is stored in the configuration file of a database. Whether so it?

    Beforehand I thank for any explanations!

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Sorry, I don't know where this information is stored. Besides, you'll need to roll the database (or tablespaces) forward in any case, since everything will be in the ROLLFORWARD PENDING state after a restore.

Posting Permissions

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