Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Location
    New York
    Posts
    14

    Unanswered: Transaction Log Mode

    Hi all,

    Can anybody tell me how I can check the value of 'Transaction Log Mode' in DB2 V7.2 on AIX platform?

    Thank you so much !!

    Sophie

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Do a:

    GET DATABASE CONFIGURATION FOR database-alias SHOW DETAIL

    If the following parameters are set like below, you have circular logging. If either one of these parms is set, you have forward recovery enabled.

    Log retain for recovery status = NO
    User exit for logging status =

    See the Command Rerference for more information on this command.
    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
    Nov 2003
    Location
    New York
    Posts
    14
    Thank you so much !!

Posting Permissions

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