Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2007
    Posts
    62

    Unanswered: Current db2 log chain ?

    Hello,

    running db2 v9.5 on AIX v6.1
    I'm writing a script and want to get current db2 log chain.

    Using VENDOR not DISK:.. as log archive target.
    Any db2 commands to do that ?

    thanks
    Vilius

  2. #2
    Join Date
    Jan 2010
    Posts
    335
    It depends on the Options of the 3rd Party tools. If they can display the current logchain.

    I don't know any db2 command to see the current logchain. DB2 writes an entry in db2diag.log for each archived logfile. Maybe you can parse the db2diag.log. We are using TSM and the entries have the eduid 5772.

    > db2diag -eduid 5772

    ...
    2010-01-19-07.11.04.328000+060 I11713613F439 LEVEL: Warning
    PID : 820 TID : 5772 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000
    EDUID : 5772 EDUNAME: db2logmgr (DBNAME)
    FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3180
    MESSAGE : Completed archive for log file S0000544.LOG to TSM chain 1 from
    ...

    Cheers
    nvk

  3. #3
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    list history archive log should also give you the current log chain (look for C0000001, C0000002, etc...)

Posting Permissions

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