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 35. 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 35:

1. 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.

2. 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.

3. The HeadExtentID is 1, indicating that the head of the log currently resides in log file S0000001.LOG.

4. 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>.

5. 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.

6. 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.

7. 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.

8. 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.

9. The next log record at LSN <0:0:0:54192> commits the message that was put under syncpoint.

10. 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>.

11. The next log record gets the message that was put to Queue2 by the other Put Message log record.

12. The MQGET under syncpoint has been committed as indicated by the Commit Transaction log record at <0:0:0:55108>.

13. 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.

14. The following Put Message records a persistent message put to Queue2. This shares the same XTranid as the previous log record.

15. 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.

16. 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.

17. 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.

 

WebSphere is a trademark of the IBM Corporation in the United States, other countries, or both.

 

IBM is a trademark of the IBM Corporation in the United States, other countries, or both.