Appendix H. Example of a log file

This section contains an example of the output from a dmpmqlog command. The dump, which started at the LSN of a specific log record, was produced using the following command:

 dmpmqlog -mtestqm -s0:0:0:44162

Figure 44. Example dmpmqlog output

AMQ7701: DMPMQLOG command is starting.
LOG FILE HEADER
***************
 
counter1  . . . : 23                   counter2  . . . : 23
FormatVersion . : 2                    logtype . . . . : 10
logactive . . . : 3                    loginactive . . : 2
logsize . . . . : 1024       pages
baselsn . . . . : <0:0:0:0>
nextlsn . . . . : <0:0:0:60864>
lowtranlsn  . . : <0:0:0:0>
minbufflsn  . . : <0:0:0:58120>
headlsn . . . . : <0:0:0:58120>
taillsn . . . . : <0:0:0:60863>
logfilepath . . : ""
hflag1  . . . . : 1
               -> CONSISTENT
               -> CIRCULAR
HeadExtentID  . : 1                    LastEID . . . . : 846249092
LogId . . . . . : 846249061            LastCommit  . . : 0
FirstArchNum  . : 4294967295           LastArchNum . . : 4294967295
nextArcFile . . : 4294967295           firstRecFile  . : 4294967295
firstDlteFile . : 4294967295           lastDeleteFile  : 4294967295
RecHeadFile . . : 4294967295           FileCount . . . : 3
frec_trunclsn . : <0:0:0:0>
frec_readlsn  . : <0:0:0:0>
frec_extnum . . : 0                    LastCId . . . . : 0
onlineBkupEnd . : 0                    softmax . . . . : 4194304
 
 
LOG RECORD - LSN <0:0:0:44162>
**********
 
HLG Header: lrecsize 212, version 1, rmid 0, eyecatcher HLRH
 
LogRecdType . . : ALM Start Checkpoint (1025)
Eyecatcher  . . : ALRH                 Version . . . . : 1
LogRecdLen  . . : 192                  LogRecdOwnr . . : 1024   (ALM)
XTranid . . . . : TranType: NULL
QueueName . . . : NULL
Qid . . . . . . : {NULL_QID}
ThisLSN . . . . : <0:0:0:0>
PrevLSN . . . . : <0:0:0:0>
 
No data for Start Checkpoint Record

LOG RECORD - LSN <0:0:0:44374>
**********
 
HLG Header: lrecsize 220, version 1, rmid 0, eyecatcher HLRH
 
LogRecdType . . : ATM Transaction Table (773)
Eyecatcher  . . : ALRH                 Version . . . . : 1
LogRecdLen  . . : 200                  LogRecdOwnr . . : 768    (ATM)
XTranid . . . . : TranType: NULL
QueueName . . . : NULL
Qid . . . . . . : {NULL_QID}
ThisLSN . . . . : <0:0:0:0>
PrevLSN . . . . : <0:0:0:0>
 
Version . . . . : 1
TranCount . . . : 0
 
 
LOG RECORD - LSN <0:0:0:44594>
**********
 
HLG Header: lrecsize 1836, version 1, rmid 0, eyecatcher HLRH
 
LogRecdType . . : Transaction Participants (1537)
Eyecatcher  . . : ALRH                 Version . . . . : 1
LogRecdLen  . . : 1816                 LogRecdOwnr . . : 1536   (T)
XTranid . . . . : TranType: NULL
QueueName . . . : NULL
Qid . . . . . . : {NULL_QID}
ThisLSN . . . . : <0:0:0:0>
PrevLSN . . . . : <0:0:0:0>
 
Id. . . . . . . : TLPH
Version . . . . : 1                    Flags . . . . . : 3
Count . . . . . : 2
 
Participant Entry 0
RMName  . . . . : DB2 MQBankDB
RMID  . . . . . : 1
SwitchFile  . . : /Development/sbolam/build/devlib/tstxasw
XAOpenString  . :
XACloseString . :
 
Participant Entry 1
RMName  . . . . : DB2 MQBankDB
RMID  . . . . . : 2
SwitchFile  . . : /Development/sbolam/build/devlib/tstxasw
XAOpenString  . :
XACloseString . :

LOG RECORD - LSN <0:0:0:46448>
**********
 
HLG Header: lrecsize 236, version 1, rmid 0, eyecatcher HLRH
 
LogRecdType . . : ALM End Checkpoint (1026)
Eyecatcher  . . : ALRH                 Version . . . . : 1
LogRecdLen  . . : 216                  LogRecdOwnr . . : 1024   (ALM)
XTranid . . . . : TranType: NULL
QueueName . . . : NULL
Qid . . . . . . : {NULL_QID}
ThisLSN . . . . : <0:0:0:0>
PrevLSN . . . . : <0:0:0:0>
 
ChkPtLSN  . . . : <0:0:0:44162>
OldestLSN . . . : <0:0:0:0>
MediaLSN  . . . : <0:0:0:0>
 
 
LOG RECORD - LSN <0:0:0:52262>
**********
 
HLG Header: lrecsize 220, version 1, rmid 0, eyecatcher HLRH
 
LogRecdType . . : ATM Start Transaction (769)
Eyecatcher  . . : ALRH                 Version . . . . : 1
LogRecdLen  . . : 200                  LogRecdOwnr . . : 768    (ATM)
XTranid . . . . : TranType: MQI    TranNum{High 0, Low 1}
QueueName . . . : NULL
Qid . . . . . . : {NULL_QID}
ThisLSN . . . . : <0:0:0:0>
PrevLSN . . . . : <0:0:0:0>
 
Version . . . . : 1
SoftLogLimit  . : 10000

LOG RECORD - LSN <0:0:0:52482>
**********
 
HLG Header: lrecsize 730, version 1, rmid 0, eyecatcher HLRH
 
LogRecdType . . : AQM Put Message (257)
Eyecatcher  . . : ALRH                 Version . . . . : 1
LogRecdLen  . . : 710                  LogRecdOwnr . . : 256    (AQM)
XTranid . . . . : TranType: MQI    TranNum{High 0, Low 1}
QueueName . . . : Queue1
Qid . . . . . . : {Hash 196836031, Counter: 0}
ThisLSN . . . . : <0:0:0:0>
PrevLSN . . . . : <0:0:0:52262>
 
Version . . . . : 3
SpcIndex  . . . : 1
PrevLink.Locn . : 36                   PrevLink.Length : 8
PrevDataLink  . : {High 0, Low 2048}
Data.Locn . . . : 2048                 Data.Length . . : 486
Data  . . . . . :
00000:  41 51 52 48 00 00 00 04 FF FF FF FF FF FF FF FF    AQRH............
00016:  00 00 00 00 00 00 00 00 00 00 00 01 00 01 01 C0    ...............Á
00032:  00 00 00 00 00 00 00 01 00 00 00 22 00 00 00 00    ..........."....
00048:  00 00 00 00 41 4D 51 20 74 65 73 74 71 6D 20 20    ....AMQ testqm
00064:  20 20 20 20 33 80 2D D2 00 00 10 13 00 00 00 00        3EUR-&box.........
00080:  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    ................
00096:  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    ................
00112:  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 01    ................
00128:  00 00 00 00 00 00 00 22 00 00 00 00 00 00 00 00    ......."........
00144:  00 00 00 00 00 00 00 C9 2C B5 C0 25 FF FF FF FF    .......&box.,&mu.À%....
00160:  4D 44 20 20 00 00 00 01 00 00 00 00 00 00 00 08    MD  ............
00176:  00 00 00 00 00 00 01 11 00 00 03 33 20 20 20 20    ...........3
00192:  20 20 20 20 00 00 00 00 00 00 00 01 20 20 20 20        ........
00208:  20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
00224:  20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
00240:  20 20 20 20 20 20 20 20 20 20 20 20 74 65 73 74                test
00256:  71 6D 20 20 20 20 20 20 20 20 20 20 20 20 20 20    qm
00272:  20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
00288:  20 20 20 20 20 20 20 20 20 20 20 20 73 62 6F 6C                sbol
00304:  61 6D 20 20 20 20 20 20 04 37 34 38 30 00 00 00    am      .7480...
00320:  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    ................
00336:  00 00 00 00 00 00 00 00 20 20 20 20 20 20 20 20    ........
00352:  20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
00368:  20 20 20 20 20 20 20 20 00 00 00 06 75 74 7A 61            ....utza
00384:  70 69 20 20 20 20 20 20 20 20 20 20 20 20 20 20    pi
00400:  20 20 20 20 20 20 20 20 31 39 39 37 30 35 31 39            19970519
00416:  31 30 34 32 31 35 32 30 20 20 20 20 00 00 00 00    10421520    ....
00432:  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    ................
00448:  50 65 72 73 69 73 74 65 6E 74 20 6D 65 73 73 61    Persistent messa
00464:  67 65 20 70 75 74 20 75 6E 64 65 72 20 73 79 6E    ge put under syn
00480:  63 70 6F 69 6E 74                                  cpoint

LOG RECORD - LSN <0:0:0:53458>
**********
 
HLG Header: lrecsize 734, version 1, rmid 0, eyecatcher HLRH
 
LogRecdType . . : AQM Put Message (257)
Eyecatcher  . . : ALRH                 Version . . . . : 1
LogRecdLen  . . : 714                  LogRecdOwnr . . : 256    (AQM)
XTranid . . . . : TranType: NULL
QueueName . . . : Queue2
Qid . . . . . . : {Hash 184842943, Counter: 2}
ThisLSN . . . . : <0:0:0:0>
PrevLSN . . . . : <0:0:0:0>
 
Version . . . . : 3
SpcIndex  . . . : 1
PrevLink.Locn . : 36                   PrevLink.Length : 8
PrevDataLink  . : {High 0, Low 2048}
Data.Locn . . . : 2048                 Data.Length . . : 490
Data  . . . . . :
00000:  41 51 52 48 00 00 00 04 FF FF FF FF FF FF FF FF    AQRH............
00016:  00 00 00 00 00 00 00 00 00 00 00 01 00 01 01 C0    ...............À
00032:  00 00 00 00 00 00 00 01 00 00 00 26 00 00 00 00    ...........&;...
00048:  00 00 00 00 41 4D 51 20 74 65 73 74 71 6D 20 20    ....AMQ testqm
00064:  20 20 20 20 33 80 2D D2 00 00 10 13 00 00 00 00        3EUR-&box.........
00080:  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    ................
00096:  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    ................
00112:  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 01    ................
00128:  00 00 00 00 00 00 00 26 00 00 00 00 00 00 00 00    .......&;.......
00144:  00 00 00 00 00 00 00 C9 2C B6 D8 DD FF FF FF FF    .......&box.,.&theta......
00160:  4D 44 20 20 00 00 00 01 00 00 00 00 00 00 00 08    MD  ............
00176:  00 00 00 00 00 00 01 11 00 00 03 33 20 20 20 20    ...........3
00192:  20 20 20 20 00 00 00 00 00 00 00 01 20 20 20 20        ........
00208:  20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
00224:  20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
00240:  20 20 20 20 20 20 20 20 20 20 20 20 74 65 73 74                test
00256:  71 6D 20 20 20 20 20 20 20 20 20 20 20 20 20 20    qm
00272:  20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
00288:  20 20 20 20 20 20 20 20 20 20 20 20 73 62 6F 6C                sbol
00304:  61 6D 20 20 20 20 20 20 04 37 34 38 30 00 00 00    am      .7480...
00320:  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    ................
00336:  00 00 00 00 00 00 00 00 20 20 20 20 20 20 20 20    ........
00352:  20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
00368:  20 20 20 20 20 20 20 20 00 00 00 06 75 74 7A 61            ....utza
00384:  70 69 20 20 20 20 20 20 20 20 20 20 20 20 20 20    pi
00400:  20 20 20 20 20 20 20 20 31 39 39 37 30 35 31 39            19970519
00416:  31 30 34 33 32 37 30 36 20 20 20 20 00 00 00 00    10432706    ....
00432:  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    ................
00448:  50 65 72 73 69 73 74 65 6E 74 20 6D 65 73 73 61    Persistent messa
00464:  67 65 20 6E 6F 74 20 70 75 74 20 75 6E 64 65 72    ge not put under
00480:  20 73 79 6E 63 70 6F 69 6E 74                       syncpoint

LOG RECORD - LSN <0:0:0:54192>
**********
 
HLG Header: lrecsize 216, version 1, rmid 0, eyecatcher HLRH
 
LogRecdType . . : ATM Commit Transaction (774)
Eyecatcher  . . : ALRH                 Version . . . . : 1
LogRecdLen  . . : 196                  LogRecdOwnr . . : 768    (ATM)
XTranid . . . . : TranType: MQI    TranNum{High 0, Low 1}
QueueName . . . : NULL
Qid . . . . . . : {NULL_QID}
ThisLSN . . . . : <0:0:0:0>
PrevLSN . . . . : <0:0:0:52482>
 
Version . . . . : 1
 
 
LOG RECORD - LSN <0:0:0:54408>
**********
 
HLG Header: lrecsize 220, version 1, rmid 0, eyecatcher HLRH
 
LogRecdType . . : ATM Start Transaction (769)
Eyecatcher  . . : ALRH                 Version . . . . : 1
LogRecdLen  . . : 200                  LogRecdOwnr . . : 768    (ATM)
XTranid . . . . : TranType: MQI    TranNum{High 0, Low 3}
QueueName . . . : NULL
Qid . . . . . . : {NULL_QID}
ThisLSN . . . . : <0:0:0:0>
PrevLSN . . . . : <0:0:0:0>
 
Version . . . . : 1
SoftLogLimit  . : 10000
 
 
LOG RECORD - LSN <0:0:0:54628>
**********
 
HLG Header: lrecsize 240, version 1, rmid 0, eyecatcher HLRH
 
LogRecdType . . : AQM Get Message (259)
Eyecatcher  . . : ALRH                 Version . . . . : 1
LogRecdLen  . . : 220                  LogRecdOwnr . . : 256    (AQM)
XTranid . . . . : TranType: MQI    TranNum{High 0, Low 3}
QueueName . . . : Queue1
Qid . . . . . . : {Hash 196836031, Counter: 0}
ThisLSN . . . . : <0:0:0:0>
PrevLSN . . . . : <0:0:0:54408>
 
Version . . . . : 2
SpcIndex  . . . : 1                    QPriority . . . : 0
PrevLink.Locn . : 36                   PrevLink.Length : 8
PrevDataLink  . : {High 4294967295, Low 4294967295}

LOG RECORD - LSN <0:0:0:54868>
**********
 
HLG Header: lrecsize 240, version 1, rmid 0, eyecatcher HLRH
 
LogRecdType . . : AQM Get Message (259)
Eyecatcher  . . : ALRH                 Version . . . . : 1
LogRecdLen  . . : 220                  LogRecdOwnr . . : 256    (AQM)
XTranid . . . . : TranType: NULL
QueueName . . . : Queue2
Qid . . . . . . : {Hash 184842943, Counter: 2}
ThisLSN . . . . : <0:0:0:0>
PrevLSN . . . . : <0:0:0:0>
 
Version . . . . : 2
SpcIndex  . . . : 1                    QPriority . . . : 0
PrevLink.Locn . : 36                   PrevLink.Length : 8
PrevDataLink  . : {High 4294967295, Low 4294967295}
 
 
LOG RECORD - LSN <0:0:0:55108>
**********
 
HLG Header: lrecsize 216, version 1, rmid 0, eyecatcher HLRH
 
LogRecdType . . : ATM Commit Transaction (774)
Eyecatcher  . . : ALRH                 Version . . . . : 1
LogRecdLen  . . : 196                  LogRecdOwnr . . : 768    (ATM)
XTranid . . . . : TranType: MQI    TranNum{High 0, Low 3}
QueueName . . . : NULL
Qid . . . . . . : {NULL_QID}
ThisLSN . . . . : <0:0:0:0>
PrevLSN . . . . : <0:0:0:54628>
 
Version . . . . : 1
 
 
LOG RECORD - LSN <0:0:0:55324>
**********
 
HLG Header: lrecsize 220, version 1, rmid 0, eyecatcher HLRH
 
LogRecdType . . : ATM Start Transaction (769)
Eyecatcher  . . : ALRH                 Version . . . . : 1
LogRecdLen  . . : 200                  LogRecdOwnr . . : 768    (ATM)
XTranid . . . . : TranType: XA
   XID: formatID 5067085, gtrid_length 14, bqual_length 4
        gtrid [3270BDB40000102374657374716D]
        bqual [00000001]
QueueName . . . : NULL
Qid . . . . . . : {NULL_QID}
ThisLSN . . . . : <0:0:0:0>
PrevLSN . . . . : <0:0:0:0>
 
Version . . . . : 1
SoftLogLimit  . : 10000

LOG RECORD - LSN <0:0:0:55544>
**********
 
HLG Header: lrecsize 738, version 1, rmid 0, eyecatcher HLRH
 
LogRecdType . . : AQM Put Message (257)
Eyecatcher  . . : ALRH                 Version . . . . : 1
LogRecdLen  . . : 718                  LogRecdOwnr . . : 256    (AQM)
XTranid . . . . : TranType: XA
   XID: formatID 5067085, gtrid_length 14, bqual_length 4
        gtrid [3270BDB40000102374657374716D]
        bqual [00000001]
QueueName . . . : Queue2
Qid . . . . . . : {Hash 184842943, Counter: 2}
ThisLSN . . . . : <0:0:0:0>
PrevLSN . . . . : <0:0:0:55324>
 
Version . . . . : 3
SpcIndex  . . . : 1
PrevLink.Locn . : 36                   PrevLink.Length : 8
PrevDataLink  . : {High 0, Low 2048}
Data.Locn . . . : 2048                 Data.Length . . : 494
Data  . . . . . :
00000:  41 51 52 48 00 00 00 04 FF FF FF FF FF FF FF FF    AQRH............
00016:  00 00 00 00 00 00 00 00 00 00 00 01 00 01 01 C0    ...............À
00032:  00 00 00 00 00 00 00 01 00 00 00 2A 00 00 00 00    ...........*....
00048:  00 00 00 01 41 4D 51 20 74 65 73 74 71 6D 20 20    ....AMQ testqm
00064:  20 20 20 20 33 80 2D D2 00 00 10 13 00 00 00 00        3EUR-&box.........
00080:  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    ................
00096:  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    ................
00112:  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 01    ................
00128:  00 00 00 00 00 00 00 2A 00 00 00 00 00 00 00 00    .......*........
00144:  00 00 00 00 00 00 00 C9 2C B8 3E E8 FF FF FF FF    .......&box.,&cplus.>.....
00160:  4D 44 20 20 00 00 00 01 00 00 00 00 00 00 00 08    MD  ............
00176:  00 00 00 00 00 00 01 11 00 00 03 33 20 20 20 20    ...........3
00192:  20 20 20 20 00 00 00 00 00 00 00 01 20 20 20 20        ........
00208:  20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
00224:  20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
00240:  20 20 20 20 20 20 20 20 20 20 20 20 74 65 73 74                test
00256:  71 6D 20 20 20 20 20 20 20 20 20 20 20 20 20 20    qm
00272:  20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
00288:  20 20 20 20 20 20 20 20 20 20 20 20 73 62 6F 6C                sbol
00304:  61 6D 20 20 20 20 20 20 04 37 34 38 30 00 00 00    am      .7480...
00320:  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    ................
00336:  00 00 00 00 00 00 00 00 20 20 20 20 20 20 20 20    ........
00352:  20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
00368:  20 20 20 20 20 20 20 20 00 00 00 06 75 74 7A 61            ....utza
00384:  70 69 20 20 20 20 20 20 20 20 20 20 20 20 20 20    pi
00400:  20 20 20 20 20 20 20 20 31 39 39 37 30 35 31 39            19970519
00416:  31 30 34 34 35 38 37 32 20 20 20 20 00 00 00 00    10445872    ....
00432:  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00    ................
00448:  41 6E 6F 74 68 65 72 20 70 65 72 73 69 73 74 65    Another persiste
00464:  6E 74 20 6D 65 73 73 61 67 65 20 70 75 74 20 75    nt message put u
00480:  6E 64 65 72 20 73 79 6E 63 70 6F 69 6E 74          nder syncpoint

LOG RECORD - LSN <0:0:0:56282>
**********
 
HLG Header: lrecsize 216, version 1, rmid 0, eyecatcher HLRH
 
LogRecdType . . : ATM Prepare Transaction (770)
Eyecatcher  . . : ALRH                 Version . . . . : 1
LogRecdLen  . . : 196                  LogRecdOwnr . . : 768    (ATM)
XTranid . . . . : TranType: XA
   XID: formatID 5067085, gtrid_length 14, bqual_length 4
        gtrid [3270BDB40000102374657374716D]
        bqual [00000001]
QueueName . . . : NULL
Qid . . . . . . : {NULL_QID}
ThisLSN . . . . : <0:0:0:0>
PrevLSN . . . . : <0:0:0:55544>
 
Version . . . . : 1
 
 
LOG RECORD - LSN <0:0:0:56498>
**********
 
HLG Header: lrecsize 708, version 1, rmid 0, eyecatcher HLRH
 
LogRecdType . . : Transaction Prepared (1538)
Eyecatcher  . . : ALRH                 Version . . . . : 1
LogRecdLen  . . : 688                  LogRecdOwnr . . : 1536   (T)
XTranid . . . . : TranType: XA
   XID: formatID 5067085, gtrid_length 14, bqual_length 4
        gtrid [3270BDB40000102374657374716D]
        bqual [00000001]
QueueName . . . : NULL
Qid . . . . . . : {NULL_QID}
ThisLSN . . . . : <0:0:0:0>
PrevLSN . . . . : <0:0:0:0>
 
Id. . . . . . . : TLPR
Version . . . . : 1                    Flags . . . . . : 1
Count . . . . . : 3
 
Participant Entry 0
RMID  . . . . . : 0                    State . . . . . : 2
 
Participant Entry 1
RMID  . . . . . : 1                    State . . . . . : 2
 
Participant Entry 2
RMID  . . . . . : 2                    State . . . . . : 2

LOG RECORD - LSN <0:0:0:57206>
**********
 
HLG Header: lrecsize 216, version 1, rmid 0, eyecatcher HLRH
 
LogRecdType . . : ATM Commit Transaction (774)
Eyecatcher  . . : ALRH                 Version . . . . : 1
LogRecdLen  . . : 196                  LogRecdOwnr . . : 768    (ATM)
XTranid . . . . : TranType: XA
   XID: formatID 5067085, gtrid_length 14, bqual_length 4
        gtrid [3270BDB40000102374657374716D]
        bqual [00000001]
QueueName . . . : NULL
Qid . . . . . . : {NULL_QID}
ThisLSN . . . . : <0:0:0:0>
PrevLSN . . . . : <0:0:0:56282>
 
Version . . . . : 1
 
 
LOG RECORD - LSN <0:0:0:57440>
**********
 
HLG Header: lrecsize 224, version 1, rmid 0, eyecatcher HLRH
 
LogRecdType . . : Transaction Forget (1539)
Eyecatcher  . . : ALRH                 Version . . . . : 1
LogRecdLen  . . : 204                  LogRecdOwnr . . : 1536   (T)
XTranid . . . . : TranType: XA
   XID: formatID 5067085, gtrid_length 14, bqual_length 4
        gtrid [3270BDB40000102374657374716D]
        bqual [00000001]
QueueName . . . : NULL
Qid . . . . . . : {NULL_QID}
ThisLSN . . . . : <0:0:0:0>
PrevLSN . . . . : <0:0:0:0>
 
Id. . . . . . . : TLFG
Version . . . . : 1                    Flags . . . . . : 0
 
 
LOG RECORD - LSN <0:0:0:58120>
**********
 
HLG Header: lrecsize 212, version 1, rmid 0, eyecatcher HLRH
 
LogRecdType . . : ALM Start Checkpoint (1025)
Eyecatcher  . . : ALRH                 Version . . . . : 1
LogRecdLen  . . : 192                  LogRecdOwnr . . : 1024   (ALM)
XTranid . . . . : TranType: NULL
QueueName . . . : NULL
Qid . . . . . . : {NULL_QID}
ThisLSN . . . . : <0:0:0:0>
PrevLSN . . . . : <0:0:0:0>
 
No data for Start Checkpoint Record

LOG RECORD - LSN <0:0:0:58332>
**********
 
HLG Header: lrecsize 220, version 1, rmid 0, eyecatcher HLRH
 
LogRecdType . . : ATM Transaction Table (773)
Eyecatcher  . . : ALRH                 Version . . . . : 1
LogRecdLen  . . : 200                  LogRecdOwnr . . : 768    (ATM)
XTranid . . . . : TranType: NULL
QueueName . . . : NULL
Qid . . . . . . : {NULL_QID}
ThisLSN . . . . : <0:0:0:0>
PrevLSN . . . . : <0:0:0:0>
 
Version . . . . : 1
TranCount . . . : 0 
 
 
LOG RECORD - LSN <0:0:0:58552>
**********
 
HLG Header: lrecsize 1836, version 1, rmid 0, eyecatcher HLRH
 
LogRecdType . . : Transaction Participants (1537)
Eyecatcher  . . : ALRH                 Version . . . . : 1
LogRecdLen  . . : 1816                 LogRecdOwnr . . : 1536   (T)
XTranid . . . . : TranType: NULL
QueueName . . . : NULL
Qid . . . . . . : {NULL_QID}
ThisLSN . . . . : <0:0:0:0>
PrevLSN . . . . : <0:0:0:0>
 
Id. . . . . . . : TLPH
Version . . . . : 1                    Flags . . . . . : 3
Count . . . . . : 2
 
Participant Entry 0
RMName  . . . . : DB2 MQBankDB
RMID  . . . . . : 1
SwitchFile  . . : /Development/sbolam/build/devlib/tstxasw
XAOpenString  . :
XACloseString . :
 
Participant Entry 1
RMName  . . . . : DB2 MQFeeDB
RMID  . . . . . : 2
SwitchFile  . . : /Development/sbolam/build/devlib/tstxasw
XAOpenString  . :
XACloseString . :

LOG RECORD - LSN <0:0:0:60388>
**********
 
HLG Header: lrecsize 236, version 1, rmid 0, eyecatcher HLRH
 
LogRecdType . . : ALM End Checkpoint (1026)
Eyecatcher  . . : ALRH                 Version . . . . : 1
LogRecdLen  . . : 216                  LogRecdOwnr . . : 1024   (ALM)
XTranid . . . . : TranType: NULL
QueueName . . . : NULL
Qid . . . . . . : {NULL_QID}
ThisLSN . . . . : <0:0:0:0>
PrevLSN . . . . : <0:0:0:0>
 
ChkPtLSN  . . . : <0:0:0:58120>
OldestLSN . . . : <0:0:0:0>
MediaLSN  . . . : <0:0:0:0> 
 
 
LOG RECORD - LSN <0:0:0:60624>
**********
 
HLG Header: lrecsize 240, version 1, rmid 0, eyecatcher HLRH
 
LogRecdType . . : ALM Stop Queue Manager (1028)
Eyecatcher  . . : ALRH                 Version . . . . : 1
LogRecdLen  . . : 220                  LogRecdOwnr . . : 1024   (ALM)
XTranid . . . . : TranType: NULL
QueueName . . . : NULL
Qid . . . . . . : {NULL_QID}
ThisLSN . . . . : <0:0:0:0>
PrevLSN . . . . : <0:0:0:0>
 
Version . . . . : 1
StopDate  . . . : 19970519             StopTime  . . . : 10490868
SessionNumber . : 0                    ForceFlag . . . : Quiesce
 
AMQ7702: DMPMQLOG command has finished successfully.

Notes for Figure 44:

The headlsn in the Log File Header has a value of <0:0:0:58120>. This is where the dump would start if we requested a different starting LSN.
The nextlsn is <0:0:0:60864>, the LSN of the first log record that the queue manager will write when it is next restarted.
The HeadExtentID is 1, indicating that the head of the log currently resides in log file S0000001.LOG.
The first log record formatted is a Start Checkpoint log record. The checkpoint spans a number of log records until the End CheckPoint record at <0:0:0:46448>.
One of the records logged during checkpoint is the Transaction Participants log record at <0:0:0:44594>. This details the resource managers that participate in global transactions coordinated by the queue manager.
The Start Transaction log record at <0:0:0:52262> denotes the start of a transaction. The XTranid shows a TranType of MQI, which indicates that it is a local transaction including WebSphere MQ updates only.
The next log record is a Put Message log record that records the persistent MQPUT under the syncpoint that started the transaction. The MQPUT was made to the queue Queue1 and the message data is logged as Persistent message put under syncpoint. This message has been allocated a SpcIndex of 1, which is matched to the later MQGET of this message.
The next log record at LSN <0:0:0:53458> is also a Put Message record. This persistent message was put to a different queue, Queue2, but was not made under syncpoint since the XTranid is NULL. It too has a SpcIndex of 1, which is a unique identifier for this particular queue.
The next log record at LSN <0:0:0:54192> commits the message that was put under syncpoint.
In log records <0:0:0:54408> and <0:0:0:54628> a new transaction is started by an MQGET under syncpoint for queue Queue1. The SpcIndex in the Get Message log record is 1 indicating that this was the same message that was put to Queue1 in <0:0:0:52262>.
The next log record gets the message that was put to Queue2 by the other Put Message log record.
The MQGET under syncpoint has been committed as indicated by the Commit Transaction log record at <0:0:0:55108>.
Finally an MQBEGIN is used to start a global transaction in the Start Transaction log record at <0:0:0:55324>. The XTranid in this log record has a TranType of XA.
The following Put Message records a persistent message put to Queue2. This shares the same XTranid as the previous log record.
If a Transaction Prepared log record is written for this Xtranid the transaction as a whole must be committed. The absence of such a log record can be taken as an indication that the transaction was rolled back. In this case a Transaction Prepared log record is found at <0:0:0:56498>. This records the queue manager itself as a participant with an RMID of zero. There are two further participants, their RMIDs of 1 and 2 can be matched with the previous Transaction Participants log record.
During the commit phase the XA Transaction Manager component of the queue manager does not log individual responses from the participants. The log indicates only whether the queue manager updates were committed or not. The Commit Transaction log record at <0:0:0:57206> indicates that the message was indeed committed to Queue2.
The Transaction Forget log record at <0:0:0:57440> indicates that the commit decision was also delivered to the other two resource managers. Any failure of these resource managers to commit their updates is diagnosed in the queue manager's error logs.