DB2 archive log file layout

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • mpk2012
    New Member
    • Aug 2012
    • 1

    #1

    DB2 archive log file layout

    I am trying to determine the layout of the DB2 archive log files. I am using DB2 V9.7 Express C.
    The dblognoconn.sqc reads the logs and displays the following to fetch the inserts, updates and deletes.


    Record type: Normal
    component ID: DMS log record
    function ID: Insert Record
    RID: x070000000000
    subrecord length: 58
    subrecord offset: 5656
    subrecord type: Updatable, Formatted user data
    user data fixed length: 15
    user data:
    30 30 30 30 33 30 0F 00 05 00 *000030....*
    14 00 1E 00 00 61 73 63 69 69 *.....ascii*
    69 00 00 00 54 68 69 73 20 69 *i...This.i*
    73 20 61 6E 6F 74 68 65 72 20 *s.another.*
    6E 65 77 20 72 65 73 75 6D 65 *new.resume*
    recordSize: 42

    Record type: Normal commit
    UTC transaction committed (in seconds since 70-01-01): 1280598517
    authorization ID of the application: DB2INST1
    recordSize: 97

    Record type: Normal
    component ID: DMS log record
    function ID: Delete Record
    RID: x060000000000
    subrecord length: 53
    subrecord offset: 5714
    subrecord type: Updatable, Formatted user data
    user data fixed length: 15
    user data:
    30 30 30 31 32 30 0F 00 05 00 *000120....*
    14 00 19 00 00 61 73 63 69 69 *.....ascii*
    69 00 00 00 54 68 69 73 20 69 *i...This.i*
    73 20 61 20 6E 65 77 20 72 65 *s.a.new.re*
    73 75 6D 65 2E *sume. *
    recordSize: 102

    Record type: Normal
    component ID: DMS log record
    function ID: Delete Record
    RID: x070000000000
    subrecord length: 58
    subrecord offset: 5656
    subrecord type: Updatable, Formatted user data
    user data fixed length: 15
    user data:
    30 30 30 30 33 30 0F 00 05 00 *000030....*
    14 00 1E 00 00 61 73 63 69 69 *.....ascii*
    69 00 00 00 54 68 69 73 20 69 *i...This.i*
    73 20 61 6E 6F 74 68 65 72 20 *s.another.*
    6E 65 77 20 72 65 73 75 6D 65 *new.resume*
    recordSize: 42


    Would anyone have material elaborating on the archive logfile layout.

    Thanks
    mpk
Working...