Would anybody know 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
mpk2012