In releases of CICS® before CICS Transaction Server for OS/390®, Version 1 Release 2, the user could specify the trace points to be used by the CICS DB2® attachment facility using parameters in the RCT. Trace points can no longer be user specified. The CICS DB2 attachment facility uses AP domain trace points in the range 3100 to 33FF. The contents of all trace points issued by the CICS DB2 attachment facility are documented in CICS Trace Entries.
Standard tracing performed by the CICS DB2 attachment facility is controlled by the FC (File Control) and RI (RMI) trace flags. RMI trace controls:
All other standard tracing from the attachment is controlled using File Control tracing. A large proportion of the possible trace issued from the CICS DB2 attachment facility is exception tracing which is output irrespective of RI or FC tracing being active, but is issued independently. The levels of FC and RI trace required can be set using the CICS-supplied transaction, CETR, or using SIT parameters STNTRFC= and STNTRRI=.
Figure 46 and Figure 47 show examples of the trace output from the RMI and the CICS DB2 task-related user exit, DFHD2EX1, when level 1 and level 2 RI tracing is active. In both examples, the trace shows one SQL statement being executed. The example trace in Figure 46 was output when CICS was connected to DB2 Version 5 or earlier. In this environment, the CICS DB2 task-related user exit runs on the CICS QR TCB (the main TCB), and creates subtask TCBs to run threads into DB2. The example trace in Figure 47 was output when CICS was connected to DB2 Version 6, and was using the open transaction environment. In this environment, the CICS DB2 task-related user exit runs on an open L8 mode TCB, and uses that same TCB to run threads into DB2.
CICS DB2 trace output is written to the CICS internal trace table and auxiliary trace and GTF trace destinations if active.
AP 2520 ERM ENTRY PLI-APPLICATION-CALL-TO-TRUE(DSNCSQL )
TASK-00041 KE_NUM-003F TCB-QR /007C5B60 RET-99902F92 TIME-08:39:21.5717947197 INTERVAL-00.0000141562 =000166=
1-0000 01 *. *
2-0000 C4E2D5C3 E2D8D340 *DSNCSQL *
3-0000 B60AF1D6 427901C0 *..10...{ *
4-0000 E3C5E2E3 D7F0F540 00000001 00100000 19900000 999000E0 000114E0 00000000 *TESTP05 ............r..\...\....*
0020 00000020 00007BB0 00000000 98400000 0040000A 00101100 00000000 00000000 *.....#.....q ... ..............*
0040 00000000 00000000 00000000 *............ *
AP 2522 ERM EVENT PASSING-CONTROL-TO-QR-TRUE(DSNCSQL )
TASK-00041 KE_NUM-003F TCB-QR /007C5B60 RET-99902F92 TIME-08:39:21.5718005166 INTERVAL-00.0000057968 =000167=
1-0000 01 *. *
2-0000 C4E2D5C3 E2D8D340 *DSNCSQL *
3-0000 B60AF1D6 427901C0 *..1O...{ *
4-0000 18CCB654 00042004 19044204 00000000 007A8000 007A8000 18F0005C 18F0CCD0 *.................:...:...0.*.0.}*
0020 190441C0 19044210 19044206 18F000D0 19044200 18CCB490 190441C8 190441B0 *...{.........0.}...........H....*
0040 190441AC 190441EC 18CCB5F3 190441FD 18CCB5F4 190441B4 190441B2 00020000 *...........3.......4............*
5-0000 D8D9 *QR *
AP 3180 D2EX1 ENTRY - APPLICATION REQUEST - EXEC SQL FETCH
TASK-00041 KE_NUM-003F TCB-QR /007C5B60 RET-8009E4D0 TIME-08:39:21.5718055947 INTERVAL-00.0000050781 =000168=
1-0000 02000000 00280800 001EE3C5 E2E3D7F0 F5401663 1BA501CD D1DC0002 18F0BA40 *..........TESTP05 ...v..J....0. *
0020 00000000 18F0CDB0 018D0004 *.....0...... *
2-0000 00DE6EC4 C6C8C4F2 D3D6E340 40404040 E7D7F0F5 184AA680 18DF2D78 18DCD030 *..>DFHD2LOT XP05.$w.......}.*
0020 00000000 00041FF0 00000000 18DF2E0C 18F0CDE0 00000000 00000000 FF6CD800 *.......0.........0.\.........%Q.*
0040 00000000 00000000 00000000 00000000 00000000 E3C5E2E3 D7F0F540 000C010C *....................TESTP05 ....*
0060 A000C000 00000000 00000000 00000000 C9E8D2F2 E9F2C7F1 B60AF1D6 427901C0 *..{.............IYK2Z2G1..1O...{*
0080 D1E3C9D3 D3C9F140 40404040 40404040 00000000 00000000 C7C2C9C2 D4C9E8C1 *JTILLI1 ........GBIBMIYA*
00A0 C9E8C1D8 E3C3F0F3 0AF1D642 7901C6D9 C2400003 000118F0 CD680000 00000000 *IYAQTC03.1O...FRB .....0........*
00C0 00000000 00000000 30050001 04000000 00000000 00000000 00000000 0000 *.............................. *
AP 3182 D2EX1 EVENT - POST D2EX3 THREAD TCB FOR DB2ENTRY XP05 USING PLAN TESTP05
TASK-00041 KE_NUM-003F TCB-QR /007C5B60 RET-8009E4D0 TIME-08:39:21.5719012041 INTERVAL-00.0000956093 =000169=
1-0000 010C010C A000C000 00000000 *......{..... *
2-0000 E3C5E2E3 D7F0F540 *TESTP05 *
3-0000 00DE6EC4 C6C8C4F2 D3D6E340 40404040 E7D7F0F5 184AA680 18DF2D78 18DCD030 *..>DFHD2LOT XP05.$w.......}.*
0020 00000000 00041FF0 00000000 18DF2E0C 18F0CDE0 00000000 00000000 FF6CD800 *.......0.........0.\.........%Q.*
0040 00000000 00000000 00000000 00000000 00000000 E3C5E2E3 D7F0F540 010C010C *....................TESTP05 ....*
0060 A000C000 00000000 00000000 00000000 C9E8D2F2 E9F2C7F1 B60AF1D6 427901C0 *..{.............IYK2Z2G1..1O...{*
0080 D1E3C9D3 D3C9F140 40404040 40404040 00000000 00000000 C7C2C9C2 D4C9E8C1 *JTILLI1 ........GBIBMIYA*
00A0 C9E8C1D8 E3C3F0F3 0AF1D642 7901C6D9 C2400003 000118F0 CD680000 00000000 *IYAQTC03.1O...FRB .....0........*
00C0 00000000 00000000 30050001 04000000 00000000 00000000 00000000 0000 *.............................. *
4-0000 00C86EC4 C6C8C4F2 C5D5E340 40404040 E7D7F0F5 40404040 B60AF017 63D17AC6 *.H>DFHD2ENT XP05 ..0..J:F*
0020 E3C5E2E3 D7F0F540 00000000 00000000 00000000 00000000 D1E3C9D3 D3C9F140 *TESTP05 ................JTILLI1 *
0040 00808080 80000000 67E939C4 B0188B86 B60AF017 63D17AC6 0000000C 00000003 *.........Z.D...f..0..J:F........*
0060 00000001 00000001 00000000 00000000 00000001 00000001 00000000 00000000 *................................*
0080 00000000 00000002 00000001 00000000 00000000 00000000 00000000 00000000 *................................*
00A0 00000000 00000000 00000000 00000000 18DCD030 00000000 00000000 19044210 *..................}.............*
00C0 00000000 00000000 *........ *
5-0000 03006EC4 C6C8C4F2 C3E2C240 40404040 B60AF1D7 B18F4081 18D305E0 18DF2D78 *..>DFHD2CSB ..1P.. a.L.\....*
0020 19044210 007C6420 00000000 00000000 00000000 00000000 807A7858 00000000 *.....@...................:......*
0040 18DF2DE4 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *...U............................*
0060 00000000 00000000 00000000 E3C5E2E3 D7F0F540 D1E3C9D3 D3C9F140 40404040 *............TESTP05 JTILLI1 *
0080 40404040 C5D5E3D9 E7D7F0F5 F0F0F0F1 00000000 B60AF1D7 C3208E08 C7C2C9C2 * ENTRXP050001......1PC...GBIB*
00A0 D4C9E8C1 C9E8C1D8 E3C3F0F3 0AF1D642 79010020 44000000 003C0001 00000000 *MIYAIYAQTC03.1O.................*
00C0 00000000 00000000 00000000 40404040 40404040 40404040 40404040 FF6CD800 *............ .%Q.*
00E0 C6D9C240 00030001 18F0CD68 00000000 00000000 00000000 00003005 00010400 *FRB .....0......................*
0100 00000000 00000000 00000000 00000000 00000000 00010320 00010250 9838A2F2 *...........................&q.s2*
0120 8000A118 18DCD110 18DCD188 18F0CD68 1838AEA2 18D305F8 18DCD110 19044210 *......J...Jh.0.....s.L.8..J.....*
0140 18D305E0 18DF2D78 18DCD030 98389A78 1838AA78 9838A0C2 98389E62 00000000 *.L.\......}.q.......q..Bq.......*
0160 C1D7C940 184AA680 003400EF 18DCD1A0 4C6E0034 00103220 6BC4C2F2 00000000 *API .$w.......J.<>......,DB2....*
0180 0028C4F0 F0F0F180 007C6420 1838AE4A B60AF1D7 C330BB88 00040000 041C0004 *..D0001..@.....$..1PC..h........*
01A0 19044244 00000000 40404040 40404040 40404040 40404040 40404040 40404040 *........ *
01C0 40404040 40404040 40404040 40404040 40404040 40404040 40404040 00000000 * ....*
01E0 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
0200 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
0220 00000000 00000000 00000000 00000000 00000000 00000000 00000004 18DCD2B0 *..............................K.*
0240 6E6EE399 81838540 E2A38199 A3406E6E 0100041C C9C4C5D5 00000000 00000000 *>>Trace Start >>....IDEN........*
0260 0200041C E2C9C7D5 00000000 00000000 0300041C C3E3C8C4 00000000 00000000 *....SIGN............CTHD........*
0280 0400041C C1D7C940 00000000 00000000 00000000 00000000 00000000 00000000 *....API ........................*
02A0 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
02C0 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
02E0 00000000 00000000 00000000 00000000 4C4CE399 81838540 C5958440 40404C4C *................<<Trace End <<*
DS 0004 DSSR ENTRY - FUNCTION(WAIT_MVS) RESOURCE_TYPE(DB2) ECB_ADDRESS(19044244) PURGEABLE(YES) WLM_WAIT_TYPE(OTHER_PRODUCT)
RESOURCE_NAME(LOT_ECB)
TASK-00041 KE_NUM-003F TCB-QR /007C5B60 RET-98E36990 TIME-08:39:21.5719126416 INTERVAL-00.0000114375 =000170=
1-0000 00680000 00000014 00000001 00000000 B1242040 00000000 060A0160 18DCD030 *................... .......-..}.*
0020 C4F2C3E2 18DCD030 180864CE 180874CD C4C2F240 40404040 00000028 00000000 *D2CS..}.........DB2 ........*
0040 19044244 A5200000 00010000 01000A00 00000000 18CCBB19 D3D6E36D C5C3C240 *....v...................LOT_ECB *
0060 40404040 40404040 * *
DS 0005 DSSR EXIT - FUNCTION(WAIT_MVS) RESPONSE(OK)
TASK-00041 KE_NUM-003F TCB-QR /007C5B60 RET-98E36990 TIME-08:39:22.4099274553 INTERVAL-00.2535246579* =000175=
1-0000 00680000 00000014 00000001 00000000 B1242040 00000000 060A0160 18DCD030 *................... .......-..}.*
0020 C4F2C3E2 18DCD030 180864CE 180874CD C4C2F240 40404040 00000028 00000000 *D2CS..}.........DB2 ........*
0040 19044244 A5200000 00010000 01000A00 00000000 18CCBB19 D3D6E36D C5C3C240 *....V...................LOT_ECB *
0060 40404040 40404040 * *
AP 3183 D2EX1 EVENT - AWOKEN BY D2EX3 THREAD TCB FOR DB2ENTRY XP05 USING PLAN TESTP05
TASK-00041 KE_NUM-003F TCB-QR /007C5B60 RET-8009E4D0 TIME-08:39:22.4099330334 INTERVAL-00.0000055781 =000176=
1-0000 010C010C A000C000 00000000 00000000 00000000 *......{............. *
2-0000 E3C5E2E3 D7F0F540 *TESTP05 *
3-0000 00DE6EC4 C6C8C4F2 D3D6E340 40404040 E7D7F0F5 184AA680 18DF2D78 18DCD030 *..>DFHD2LOT XP05.$w.......}.*
0020 00000000 00041FF0 00000000 18DF2E0C 18F0CDE0 00000000 00000000 FF6CD800 *.......0.........0.\.........%Q.*
0040 00000000 00000000 00000000 00000000 00000000 E3C5E2E3 D7F0F540 010C010C *....................TESTP05 ....*
0060 A000C000 00000000 00000000 00000000 C9E8D2F2 E9F2C7F1 B60AF1D6 427901C0 *..{.............IYK2Z2G1..1O...{*
0080 D1E3C9D3 D3C9F140 40404040 40404040 00000000 00000000 C7C2C9C2 D4C9E8C1 *JTILLI1 ........GBIBMIYA*
00A0 C9E8C1D8 E3C3F0F3 0AF1D642 7901C6D9 C2400003 000118F0 CDE00000 00000000 *IYAQTC03.1O...FRB .....0.\......*
00C0 00000000 00000000 30050001 04000000 00000000 00000000 00000000 0000 *.............................. *
4-0000 00C86EC4 C6C8C4F2 C5D5E340 40404040 E7D7F0F5 40404040 B60AF017 63D17AC6 *.H>DFHD2ENT XP05 ..0..J:F*
0020 E3C5E2E3 D7F0F540 00000000 00000000 00000000 00000000 D1E3C9D3 D3C9F140 *TESTP05 ................JTILLI1 *
0040 00808080 80000000 67E939C4 B0188B86 B60AF017 63D17AC6 0000000C 00000003 *.........Z.D...f..0..J:F........*
0060 00000001 00000001 00000000 00000000 00000001 00000001 00000000 00000000 *................................*
0080 00000000 00000002 00000001 00000000 00000000 00000000 00000000 00000000 *................................*
00A0 00000000 00000000 00000000 00000000 18DCD030 00000000 00000000 19044210 *..................}.............*
00C0 00000000 00000000 *........ *
5-0000 03006EC4 C6C8C4F2 C3E2C240 40404040 B60AF1D7 B18F4081 18D305E0 18DF2D78 *..>DFHD2CSB ..1P.. a.L.\....*
0020 19044210 007C6420 00000000 00000000 00000000 00000000 807A7858 00000000 *.....@...................:......*
0040 18DF2DE4 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *...U............................*
0060 00000000 00000000 00000000 E3C5E2E3 D7F0F540 D1E3C9D3 D3C9F140 40404040 *............TESTP05 JTILLI1 *
0080 40404040 C5D5E3D9 E7D7F0F5 F0F0F0F1 00000000 B60AF1D7 C3208E08 C7C2C9C2 * ENTRXP050001......1PC...GBIB*
00A0 D4C9E8C1 C9E8C1D8 E3C3F0F3 0AF1D642 79010020 44000000 003C0001 00000000 *MIYAIYAQTC03.1O.................*
00C0 00000000 00000000 00000000 40404040 40404040 40404040 40404040 FF6CD800 *............ .%Q.*
00E0 C6D9C240 00030001 18F0CDE0 00000000 00000000 00000000 00003005 00010400 *FRB .....0.\....................*
0100 00000000 00000000 00000000 00000000 00000000 00010320 00010250 9838A2F2 *...........................&q.s2*
0120 8000A118 18DCD110 18DCD188 18F0CDE0 1838AEA2 18D305F8 18DCD110 19044210 *......J...Jh.0.\...s.L.8..J.....*
0140 18D305E0 18DF2D78 18DCD030 98389A78 1838AA78 9838A0C2 98389E62 00000000 *.L.\......}.q.......q..Bq.......*
0160 C1D7C940 184AA680 003400EF 18DCD1A0 4C6E0034 00103220 6BC4C2F2 00000000 *API .$w.......J.<>......,DB2....*
0180 0028C4F0 F0F0F180 007C6420 1838AE4A B60AF1DF BEC73D08 00040000 041C0004 *..D0001..@.....$..1..G..........*
01A0 19044244 00000000 40404040 40404040 40404040 40404040 40404040 40404040 *........ *
01C0 40404040 40404040 40404040 40404040 40404040 40404040 40404040 00000000 * ....*
01E0 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
0200 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
0220 00000000 00000000 00000000 00000000 00000000 00000000 00000005 18DCD2C0 *..............................K{*
0240 6E6EE399 81838540 E2A38199 A3406E6E 0100041C C9C4C5D5 00000000 00000000 *>>Trace Start >>....IDEN........*
0260 0200041C E2C9C7D5 00000000 00000000 0300041C C3E3C8C4 00000000 00000000 *....SIGN............CTHD........*
0280 0400041C C1D7C940 00000000 00000000 0500041C C1D7C940 00000000 00000000 *....API ............API ........*
02A0 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
02C0 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
02E0 00000000 00000000 00000000 00000000 4C4CE399 81838540 C5958440 40404C4C *................<<Trace End <<*
AP 3181 D2EX1 EXIT - APPLICATION REQUEST - EXEC SQL FETCH
TASK-00041 KE_NUM-003F TCB-QR /007C5B60 RET-8009E4D0 TIME-08:39:22.4100164084 INTERVAL-00.0000833750 =000177=
1-0000 02000000 00280800 001EE3C5 E2E3D7F0 F5401663 1BA501CD D1DC0002 18F0BA40 *..........TESTP05 ...v..J....0. *
0020 00000000 18F0CDB0 018D0004 *.....0...... *
2-0000 00DE6EC4 C6C8C4F2 D3D6E340 40404040 E7D7F0F5 184AA680 18DF2D78 18DCD030 *..>DFHD2LOT XP05.$w.......}.*
0020 00000000 00041FF0 00000000 18DF2E0C 18F0CDE0 00000000 00000000 FF6CD800 *.......0.........0.\.........%Q.*
0040 00000000 00000000 00000000 00000000 00000000 E3C5E2E3 D7F0F540 010C010C *....................TESTP05 ....*
0060 A000C000 00000000 00000000 00000000 C9E8D2F2 E9F2C7F1 B60AF1D6 427901C0 *..{.............IYK2Z2G1..1O...{*
0080 D1E3C9D3 D3C9F140 40404040 40404040 00000000 00000000 C7C2C9C2 D4C9E8C1 *JTILLI1 ........GBIBMIYA*
00A0 C9E8C1D8 E3C3F0F3 0AF1D642 7901C6D9 C2400003 000118F0 CDE00000 00000000 *IYAQTC03.1O...FRB .....0.\......*
00C0 00000000 00000000 30050001 04000000 00000000 00000000 00000000 0000 *.............................. *
3-0000 00 *. *
4-0000 E2D8D3C3 C1404040 00000088 00000000 00004040 40404040 40404040 40404040 *SQLCA ...h...... *
0020 40404040 40404040 40404040 40404040 40404040 40404040 40404040 40404040 * *
0040 40404040 40404040 40404040 40404040 40404040 40404040 C4E2D540 40404040 * DSN *
0060 00000000 00000000 00000000 FFFFFFFF 00000000 00000000 40404040 40404040 *........................ *
0080 404040F0 F0F0F0F0 * 00000 *
5-0000 00C86EC4 C6C8C4F2 C5D5E340 40404040 E7D7F0F5 40404040 B60AF017 63D17AC6 *.H>DFHD2ENT XP05 ..0..J:F*
0020 E3C5E2E3 D7F0F540 00000000 00000000 00000000 00000000 D1E3C9D3 D3C9F140 *TESTP05 ................JTILLI1 *
0040 00808080 80000000 67E939C4 B0188B86 B60AF017 63D17AC6 0000000C 00000003 *.........Z.D...f..0..J:F........*
0060 00000001 00000001 00000000 00000000 00000001 00000001 00000000 00000000 *................................*
0080 00000000 00000002 00000001 00000000 00000000 00000000 00000000 00000000 *................................*
00A0 00000000 00000000 00000000 00000000 18DCD030 00000000 00000000 19044210 *..................}.............*
00C0 00000000 00000000 *........ *
6-0000 03006EC4 C6C8C4F2 C3E2C240 40404040 B60AF1D7 B18F4081 18D305E0 18DF2D78 *..>DFHD2CSB ..1P.. a.L.\....*
0020 19044210 007C6420 00000000 00000000 00000000 00000000 807A7858 00000000 *.....@...................:......*
0040 18DF2DE4 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *...U............................*
0060 00000000 00000000 00000000 E3C5E2E3 D7F0F540 D1E3C9D3 D3C9F140 40404040 *............TESTP05 JTILLI1 *
0080 40404040 C5D5E3D9 E7D7F0F5 F0F0F0F1 00000000 B60AF1D7 C3208E08 C7C2C9C2 * ENTRXP050001......1PC...GBIB*
00A0 D4C9E8C1 C9E8C1D8 E3C3F0F3 0AF1D642 79010020 44000000 003C0001 00000000 *MIYAIYAQTC03.1O.................*
00C0 00000000 00000000 00000000 40404040 40404040 40404040 40404040 FF6CD800 *............ .%Q.*
00E0 C6D9C240 00030001 18F0CDE0 00000000 00000000 00000000 00003005 00010400 *FRB .....0.\....................*
0100 00000000 00000000 00000000 00000000 00000000 00010320 00010250 9838A2F2 *...........................&q.s2*
0120 8000A118 18DCD110 18DCD188 18F0CDE0 1838AEA2 18D305F8 18DCD110 19044210 *......J...Jh.0.\...s.L.8..J.....*
0140 18D305E0 18DF2D78 18DCD030 98389A78 1838AA78 9838A0C2 98389E62 00000000 *.L.\......}.q.......q..Bq.......*
0160 C1D7C940 184AA680 003400EF 18DCD1A0 4C6E0034 00103220 6BC4C2F2 00000000 *API .$w.......J.<>......,DB2....*
0180 0028C4F0 F0F0F180 007C6420 1838AE4A B60AF1DF BEC73D08 00040000 041C0004 *..D0001..@.....$..1..G..........*
01A0 19044244 00000000 40404040 40404040 40404040 40404040 40404040 40404040 *........ *
01C0 40404040 40404040 40404040 40404040 40404040 40404040 40404040 00000000 * ....*
01E0 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
0200 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
0220 00000000 00000000 00000000 00000000 00000000 00000000 00000005 18DCD2C0 *..............................K{*
0240 6E6EE399 81838540 E2A38199 A3406E6E 0100041C C9C4C5D5 00000000 00000000 *>>Trace Start >>....IDEN........*
0260 0200041C E2C9C7D5 00000000 00000000 0300041C C3E3C8C4 00000000 00000000 *....SIGN............CTHD........*
0280 0400041C C1D7C940 00000000 00000000 0500041C C1D7C940 00000000 00000000 *....API ............API ........*
02A0 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
02C0 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
02E0 00000000 00000000 00000000 00000000 4C4CE399 81838540 C5958440 40404C4C *................<<Trace End <<*
AP 2523 ERM EVENT REGAINING-CONTROL-FROM-QR-TRUE(DSNCSQL )
TASK-00041 KE_NUM-003F TCB-QR /007C5B60 RET-99902F92 TIME-08:39:22.4100237365 INTERVAL-00.0000073281 =000178=
1-0000 01 *. *
2-0000 C4E2D5C3 E2D8D340 *DSNCSQL *
3-0000 B60AF1D6 427901C0 *..1O...{ *
4-0000 18CCB654 00042004 19044204 00000000 007A8000 007A8000 18F0005C 18F0CCD0 *.................:...:...0.*.0.}*
0020 190441C0 19044210 19044206 18F000D0 19044200 18CCBCA0 190441C8 190441B0 *...{.........0.}...........H....*
0040 190441AC 190441EC 18CCB5F3 190441FD 18CCB5F4 190441B4 190441B2 00020000 *...........3.......4............*
5-0000 D8D9 *QR *
AP 2521 ERM EXIT PLI-APPLICATION-CALL-TO-TRUE(DSNCSQL )
TASK-00041 KE_NUM-003F TCB-QR /007C5B60 RET-99902F92 TIME-08:39:22.4100312365 INTERVAL-00.0000075000 =000179=
1-0000 01 *. *
2-0000 C4E2D5C3 E2D8D340 *DSNCSQL *
3-0000 B60AF1D6 427901C0 *..1O...{ *
4-0000 E3C5E2E3 D7F0F540 00000001 00100000 19900000 999000E0 000114E0 00000000 *TESTP05 ............r..\...\....*
0020 00000020 00007BB0 00000000 98400000 0040000A 00101100 00000000 00000000 *......#.....q ... ..............*
0040 00000000 00000000 00000000 *............ *
The example trace in Figure 47 was produced when CICS was connected to DB2 Version 6.
AP 2520 ERM ENTRY PLI-APPLICATION-CALL-TO-TRUE(DSNCSQL )
TASK-00035 KE_NUM-003F TCB-QR /007C5B60 RET-99902F92 TIME-08:32:00.7673270795 INTERVAL-00.0000135312 =000162=
1-0000 01 *. *
2-0000 C4E2D5C3 E2D8D340 *DSNCSQL *
3-0000 B60AF030 A54A8EC0 *..0.v$.{ *
4-0000 E3C5E2E3 D7F0F540 00000001 00100000 19900000 999000E0 000114E0 00000000 *TESTP05 ............r..\...\....*
0020 00000020 00007BB0 00000000 98400000 0040000A 00101100 00000000 00000000 *......#.....q ... ..............*
0040 00000000 00000000 00000000 *............ *
DS 0002 DSAT ENTRY - FUNCTION(CHANGE_MODE) MODENAME(L8)
TASK-00035 KE_NUM-003F TCB-QR /007C5B60 RET-8009E318 TIME-08:32:00.7673341108 INTERVAL-00.0000070312 =000163=
1-0000 00980000 00000003 00000001 00000000 A0000040 00000000 05000102 01000002 *.q................. ............*
0020 01007450 00000000 000002B0 18CCB490 18CCB6D8 9801014C 01031498 18220F30 *...&...............Qq..<...q....*
0040 18CCBB70 1833E000 9800E8F0 00007000 190441EC 18CCBB70 00000008 D3F8D8D9 *......\.q.Y0................L8QR*
0060 18CCB638 FFFFFFFF 18CB4B00 987D9520 00000001 18DEA4A0 18DEA010 00000001 *............q'n.......u.........*
0080 00007550 18CCB776 00000000 0000E8F0 18CCBA28 18CCBA28 *...&..........Y0........ *
DS 0003 DSAT EXIT - FUNCTION(CHANGE_MODE) RESPONSE(OK)
TASK-00035 KE_NUM-003F TCB-L8000/007C6B90 RET-8009E318 TIME-08:32:00.7673710483 INTERVAL-00.0000369375 =000164=
1-0000 00980000 00000003 00000001 00000000 A0000040 00000000 05000102 01000002 *.q................. ............*
0020 01007450 00000000 000002B0 18CCB490 18CCB6D8 9801014C 01031498 18220F30 *...&...............Qq..<...q....*
0040 18CCBB70 1833E000 9800E8F0 00007000 190441EC 18CCBB70 00000001 D3F8D8D9 *......\.q.Y0................L8QR*
0060 18CCB638 FFFFFFFF 18CB4B00 987D9520 00000001 18DEA4A0 18DEA010 00000001 *............q'n.......u.........*
0080 00007550 18CCB776 00000000 0000E8F0 18CCBA28 18CCBA28 *...&..........Y0........ *
AP 2522 ERM EVENT PASSING-CONTROL-TO-OPENAPI-TRUE(DSNCSQL )
TASK-00035 KE_NUM-003F TCB-L8000/007C6B90 RET-99902F92 TIME-08:32:00.7673729077 INTERVAL-00.0000018593 =000165=
1-0000 01 *. *
2-0000 C4E2D5C3 E2D8D340 *DSNCSQL *
3-0000 B60AF030 A54A8EC0 *..0.v$.{ *
4-0000 18CCB654 0006F004 19044204 00000000 007A8000 007A8000 18F0005C 18F0CCD0 *......0..........:...:...0.*.0.}*
0020 190441C0 19044210 19044206 18F000D0 19044200 18CCB490 190441C8 190441B0 *...{.........0.}...........H....*
0040 190441AC 190441EC 18CCB5F3 190441FD 18CCB5F4 190441B4 190441B2 00020000 *...........3.......4............*
5-0000 D3F8 *L8 *
AP 3180 D2EX1 ENTRY - APPLICATION REQUEST - EXEC SQL FETCH
TASK-00035 KE_NUM-003F TCB-L8000/007C6B90 RET-8009E4D0 TIME-08:32:00.7673780483 INTERVAL-00.0000051406 =000166=
1-0000 02000000 00280800 001EE3C5 E2E3D7F0 F5401663 1BA501CD D1DC0002 18F0BA40 *..........TESTP05 ...v..J....0. *
0020 00000000 18F0CDB0 018D0004 *.....0...... *
2-0000 00DE6EC4 C6C8C4F2 D3D6E340 40404040 E7D7F0F5 184AC080 18DF2D78 18DCD030 *..>DFHD2LOT XP05.${.......}.*
0020 00000000 0006EFF0 00000000 18DF2E0C 18F0CDE0 00000000 00000000 FF6CD800 *.......0.........0.\.........%Q.*
0040 00000000 00000000 00000000 00000000 00000000 E3C5E2E3 D7F0F540 000C010C *....................TESTP05 ....*
0060 A000C000 00000000 00000000 00000000 C9E8D2F2 E9F2C7F1 B60AF030 A54A8EC0 *..{.............IYK2Z2G1..0.v$.{*
0080 D1E3C9D3 D3C9F140 40404040 40404040 00000000 00000000 C7C2C9C2 D4C9E8C1 *JTILLI1 ........GBIBMIYA*
00A0 C9E8C1D8 E3C3F0F3 0AF030A5 4A8EC6D9 C2400003 000118F0 CD680000 00000000 *IYAQTC03.0.v$.FRB .....0........*
00C0 00000000 00000000 39050001 04000000 00000000 00000000 00000000 0000 *.............................. *
AP 3250 D2D2 ENTRY - FUNCTION(DB2_API_CALL) CSUB_TOKEN(18DCD030)
TASK-00035 KE_NUM-003F TCB-L8000/007C6B90 RET-98E3321C TIME-08:32:00.7674652827 INTERVAL-00.0000872343 =000167=
1-0000 00200000 00000034 00000000 00000000 B8000000 00000000 03000100 18DCD030 *..............................}.*
2-0000 03006EC4 C6C8C4F2 C3E2C240 40404040 B60AF031 FAD0CB43 18D305E0 18DF2D78 *..>DFHD2CSB ..0..}...L.\....*
0020 19044210 007C6B90 00000000 00000000 B60AF030 A54A8EC0 00000000 00000000 *.....@,...........0.v$.{........*
0040 18DF2DE4 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *...U............................*
0060 00000000 00000000 00000000 E3C5E2E3 D7F0F540 D1E3C9D3 D3C9F140 40404040 *............TESTP05 JTILLI1 *
0080 40404040 C5D5E3D9 E7D7F0F5 F0F0F0F1 00000000 B60AF032 01359743 C7C2C9C2 * ENTRXP050001......0...p.GBIB*
00A0 D4C9E8C1 C9E8C1D8 E3C3F0F3 0AF030A5 4A8E0000 44800000 00000001 00000000 *MIYAIYAQTC03.0.v$...............*
00C0 00000000 00000000 00000000 40404040 40404040 40404040 40404040 FF6CD800 *............ .%Q.*
00E0 C6D9C240 00030001 18F0CD68 00000000 00000000 00000000 00003905 00010400 *FRB .....0......................*
0100 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
0120 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
0140 00000000 00000000 00000000 00000000 00000000 00000000 98DCD110 00000000 *........................q.J.....*
0160 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
0180 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
01A0 00000000 00000000 40404040 40404040 40404040 40404040 40404040 40404040 *........ *
01C0 40404040 40404040 40404040 40404040 40404040 40404040 40404040 00000000 * ....*
01E0 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
0200 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
0220 00000000 00000000 00000000 00000000 00000000 00000000 00000004 18DCD2B0 *..............................K.*
0240 6E6EE399 81838540 E2A38199 A3406E6E 0100035C C9C4C5D5 00000000 00000000 *>>Trace Start >>...*IDEN........*
0260 0200035C E2C9C7D5 00000000 00000000 0300035C C3E3C8C4 00000000 00000000 *...*SIGN...........*CTHD........*
0280 0400035C C1D7C940 00000000 00000000 00000000 00000000 00000000 00000000 *...*API ........................*
02A0 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
02C0 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
02E0 00000000 00000000 00000000 00000000 4C4CE399 81838540 C5958440 40404C4C *................<<Trace End <<*
3-0000 00DE6EC4 C6C8C4F2 D3D6E340 40404040 E7D7F0F5 184AC080 18DF2D78 18DCD030 *..>DFHD2LOT XP05.${.......}.*
0020 00000000 0006EFF0 00000000 18DF2E0C 18F0CDE0 00000000 00000000 FF6CD800 *.......0.........0.\.........%Q.*
0040 00000000 00000000 00000000 00000000 00000000 E3C5E2E3 D7F0F540 010C010C *....................TESTP05 ....*
0060 A000C000 00000000 00000000 00000000 C9E8D2F2 E9F2C7F1 B60AF030 A54A8EC0 *..{.............IYK2Z2G1..0.v$.{*
0080 D1E3C9D3 D3C9F140 40404040 40404040 00000000 00000000 C7C2C9C2 D4C9E8C1 *JTILLI1 ........GBIBMIYA*
00A0 C9E8C1D8 E3C3F0F3 0AF030A5 4A8EC6D9 C2400003 000118F0 CD680000 00000000 *IYAQTC03.0.v$.FRB .....0........*
00C0 00000000 00000000 39050001 04000000 00000000 00000000 00000000 0000 *.............................. *
AP 326C D2D2 EVENT - ABOUT_TO_ISSUE_DB2_API_REQUEST
TASK-00035 KE_NUM-003F TCB-L8000/007C6B90 RET-98E3321C TIME-08:32:00.7674700952 INTERVAL-00.0000048125 =000168=
1-0000 98DCD110 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *q.J.............................*
2-0000 C6D9C240 00030001 18F0CDE0 00000000 00000000 00000000 00003905 00010400 *FRB .....0.\....................*
0020 00000000 00000000 00000000 00000000 *................ *
3-0000 E3C5E2E3 D7F0F540 *TESTP05 *
4-0000 03006EC4 C6C8C4F2 C3E2C240 40404040 B60AF031 FAD0CB43 18D305E0 18DF2D78 *..>DFHD2CSB ..0..}...L.\....*
0020 19044210 007C6B90 00000000 00000000 B60AF030 A54A8EC0 00000000 00000000 *.....@,...........0.v$.{........*
0040 18DF2DE4 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *...U............................*
0060 00000000 00000000 00000000 E3C5E2E3 D7F0F540 D1E3C9D3 D3C9F140 40404040 *............TESTP05 JTILLI1 *
0080 40404040 C5D5E3D9 E7D7F0F5 F0F0F0F1 00000000 B60AF032 01359743 C7C2C9C2 * ENTRXP050001......0...p.GBIB*
00A0 D4C9E8C1 C9E8C1D8 E3C3F0F3 0AF030A5 4A8E0000 44800000 00000001 00000000 *MIYAIYAQTC03.0.v$...............*
00C0 00000000 00000000 00000000 40404040 40404040 40404040 40404040 FF6CD800 *............ .%Q.*
00E0 C6D9C240 00030001 18F0CDE0 00000000 00000000 00000000 00003905 00010400 *FRB .....0.\....................*
0100 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
0120 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
0140 00000000 00000000 00000000 00000000 00000000 00000000 98DCD110 00000000 *........................q.J.....*
0160 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
0180 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
01A0 00000000 00000000 40404040 40404040 40404040 40404040 40404040 40404040 *........ *
01C0 40404040 40404040 40404040 40404040 40404040 40404040 40404040 00000000 * ....*
01E0 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
0200 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
0220 00000000 00000000 00000000 00000000 00000000 00000000 00000004 18DCD2B0 *..............................K.*
0240 6E6EE399 81838540 E2A38199 A3406E6E 0100035C C9C4C5D5 00000000 00000000 *>>Trace Start >>...*IDEN........*
0260 0200035C E2C9C7D5 00000000 00000000 0300035C C3E3C8C4 00000000 00000000 *...*SIGN...........*CTHD........*
0280 0400035C C1D7C940 00000000 00000000 00000000 00000000 00000000 00000000 *...*API ........................*
02A0 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
02C0 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
02E0 00000000 00000000 00000000 00000000 4C4CE399 81838540 C5958440 40404C4C *................<<Trace End <<*
5-0000 00DE6EC4 C6C8C4F2 D3D6E340 40404040 E7D7F0F5 184AC080 18DF2D78 18DCD030 *..>DFHD2LOT XP05.${.......}.*
0020 00000000 0006EFF0 00000000 18DF2E0C 18F0CDE0 00000000 00000000 FF6CD800 *.......0.........0.\.........%Q.*
0040 00000000 00000000 00000000 00000000 00000000 E3C5E2E3 D7F0F540 010C010C *....................TESTP05 ....*
0060 A000C000 00000000 00000000 00000000 C9E8D2F2 E9F2C7F1 B60AF030 A54A8EC0 *..{.............IYK2Z2G1..0.v$.{*
0080 D1E3C9D3 D3C9F140 40404040 40404040 00000000 00000000 C7C2C9C2 D4C9E8C1 *JTILLI1 ........GBIBMIYA*
00A0 C9E8C1D8 E3C3F0F3 0AF030A5 4A8EC6D9 C2400003 000118F0 CD680000 00000000 *IYAQTC03.0.v$.FRB .....0........*
00C0 00000000 00000000 39050001 04000000 00000000 00000000 00000000 0000 *.............................. *
AP 326D D2D2 EVENT - RETURN_FROM_DB2_API_REQUEST
TASK-00035 KE_NUM-003F TCB-L8000/007C6B90 RET-98E3321C TIME-08:32:00.7678738139 INTERVAL-00.0004037187 =000169=
1-0000 98DCD110 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *q.J.............................*
2-0000 C6D9C240 00030001 18F0CDE0 00000000 00000000 00000000 00003905 00010400 *FRB .....0.\....................*
0020 00000000 00000000 00000000 00000000 *................ *
3-0000 E3C5E2E3 D7F0F540 *TESTP05 *
4-0000 03006EC4 C6C8C4F2 C3E2C240 40404040 B60AF031 FAD0CB43 18D305E0 18DF2D78 *..>DFHD2CSB ..0..}...L.\....*
0020 19044210 007C6B90 00000000 00000000 B60AF030 A54A8EC0 00000000 00000000 *.....@,...........0.v$.{........*
0040 18DF2DE4 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *...U............................*
0060 00000000 00000000 00000000 E3C5E2E3 D7F0F540 D1E3C9D3 D3C9F140 40404040 *............TESTP05 JTILLI1 *
0080 40404040 C5D5E3D9 E7D7F0F5 F0F0F0F1 00000000 B60AF032 01359743 C7C2C9C2 * ENTRXP050001......0...p.GBIB*
00A0 D4C9E8C1 C9E8C1D8 E3C3F0F3 0AF030A5 4A8E0000 44800000 00000001 00000000 *MIYAIYAQTC03.0.v$...............*
00C0 00000000 00000000 00000000 40404040 40404040 40404040 40404040 FF6CD800 *............ .%Q.*
00E0 C6D9C240 00030001 18F0CDE0 00000000 00000000 00000000 00003905 00010400 *FRB .....0.\....................*
0100 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
0120 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
0140 00000000 00000000 00000000 00000000 00000000 00000000 98DCD110 00000000 *........................q.J.....*
0160 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
0180 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
01A0 00000000 00000000 40404040 40404040 40404040 40404040 40404040 40404040 *........ *
01C0 40404040 40404040 40404040 40404040 40404040 40404040 40404040 00000000 * ....*
01E0 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
0200 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
0220 00000000 00000000 00000000 00000000 00000000 00000000 00000005 18DCD2C0 *..............................K{*
0240 6E6EE399 81838540 E2A38199 A3406E6E 0100035C C9C4C5D5 00000000 00000000 *>>Trace Start >>...*IDEN........*
0260 0200035C E2C9C7D5 00000000 00000000 0300035C C3E3C8C4 00000000 00000000 *...*SIGN...........*CTHD........*
0280 0400035C C1D7C940 00000000 00000000 0500035C C1D7C940 00000000 00000000 *...*API ...........*API ........*
02A0 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
02C0 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
02E0 00000000 00000000 00000000 00000000 4C4CE399 81838540 C5958440 40404C4C *................<<Trace End <<*
5-0000 00DE6EC4 C6C8C4F2 D3D6E340 40404040 E7D7F0F5 184AC080 18DF2D78 18DCD030 *..>DFHD2LOT XP05.${.......}.*
0020 00000000 0006EFF0 00000000 18DF2E0C 18F0CDE0 00000000 00000000 FF6CD800 *.......0.........0.\.........%Q.*
0040 00000000 00000000 00000000 00000000 00000000 E3C5E2E3 D7F0F540 010C010C *....................TESTP05 ....*
0060 A000C000 00000000 00000000 00000000 C9E8D2F2 E9F2C7F1 B60AF030 A54A8EC0 *..{.............IYK2Z2G1..0.v$.{*
0080 D1E3C9D3 D3C9F140 40404040 40404040 00000000 00000000 C7C2C9C2 D4C9E8C1 *JTILLI1 ........GBIBMIYA*
00A0 C9E8C1D8 E3C3F0F3 0AF030A5 4A8EC6D9 C2400003 000118F0 CD680000 00000000 *IYAQTC03.0.v$.FRB .....0........*
00C0 00000000 00000000 39050001 04000000 00000000 00000000 00000000 0000 *.............................. *
AP 3251 D2D2 EXIT - FUNCTION(DB2_API_CALL) RESPONSE(OK)
TASK-00035 KE_NUM-003F TCB-L8000/007C6B90 RET-98E3321C TIME-08:32:00.7697274233 INTERVAL-00.0018536093 =000170=
1-0000 00200000 00000034 00000000 00000000 B8000000 00000000 03000100 18DCD030 *..............................}.*
2-0000 03006EC4 C6C8C4F2 C3E2C240 40404040 B60AF031 FAD0CB43 18D305E0 18DF2D78 *..>DFHD2CSB ..0..}...L.\....*
0020 19044210 007C6B90 00000000 00000000 B60AF030 A54A8EC0 00000000 00000000 *.....@,...........0.v$.{........*
0040 18DF2DE4 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *...U............................*
0060 00000000 00000000 00000000 E3C5E2E3 D7F0F540 D1E3C9D3 D3C9F140 40404040 *............TESTP05 JTILLI1 *
0080 40404040 C5D5E3D9 E7D7F0F5 F0F0F0F1 00000000 B60AF032 01359743 C7C2C9C2 * ENTRXP050001......0...p.GBIB*
00A0 D4C9E8C1 C9E8C1D8 E3C3F0F3 0AF030A5 4A8E0000 44800000 00000001 00000000 *MIYAIYAQTC03.0.v$...............*
00C0 00000000 00000000 00000000 40404040 40404040 40404040 40404040 FF6CD800 *............ .%Q.*
00E0 C6D9C240 00030001 18F0CDE0 00000000 00000000 00000000 00003905 00010400 *FRB .....0.\....................*
0100 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
0120 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
0140 00000000 00000000 00000000 00000000 00000000 00000000 98DCD110 00000000 *........................q.J.....*
0160 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
0180 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
01A0 00000000 00000000 40404040 40404040 40404040 40404040 40404040 40404040 *........ *
01C0 40404040 40404040 40404040 40404040 40404040 40404040 40404040 00000000 * ....*
01E0 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
0200 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
0220 00000000 00000000 00000000 00000000 00000000 00000000 00000005 18DCD2C0 *..............................K{*
0240 6E6EE399 81838540 E2A38199 A3406E6E 0100035C C9C4C5D5 00000000 00000000 *>>Trace Start >>...*IDEN........*
0260 0200035C E2C9C7D5 00000000 00000000 0300035C C3E3C8C4 00000000 00000000 *...*SIGN...........*CTHD........*
0280 0400035C C1D7C940 00000000 00000000 0500035C C1D7C940 00000000 00000000 *...*API ...........*API ........*
02A0 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
02C0 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
02E0 00000000 00000000 00000000 00000000 4C4CE399 81838540 C5958440 40404C4C *................<<Trace End <<*
3-0000 00DE6EC4 C6C8C4F2 D3D6E340 40404040 E7D7F0F5 184AC080 18DF2D78 18DCD030 *..>DFHD2LOT XP05.${.......}.*
0020 00000000 0006EFF0 00000000 18DF2E0C 18F0CDE0 00000000 00000000 FF6CD800 *.......0.........0.\.........%Q.*
0040 00000000 00000000 00000000 00000000 00000000 E3C5E2E3 D7F0F540 010C010C *....................TESTP05 ....*
0060 A000C000 00000000 00000000 00000000 C9E8D2F2 E9F2C7F1 B60AF030 A54A8EC0 *..{.............IYK2Z2G1..0.v$.{*
0080 D1E3C9D3 D3C9F140 40404040 40404040 00000000 00000000 C7C2C9C2 D4C9E8C1 *JTILLI1 ........GBIBMIYA*
00A0 C9E8C1D8 E3C3F0F3 0AF030A5 4A8EC6D9 C2400003 000118F0 CDE00000 00000000 *IYAQTC03.0.v$.FRB .....0.\......*
00C0 00000000 00000000 39050001 04000000 00000000 00000000 00000000 0000 *.............................. *
AP 3181 D2EX1 EXIT - APPLICATION REQUEST - EXEC SQL FETCH
TASK-00035 KE_NUM-003F TCB-L8000/007C6B90 RET-8009E4D0 TIME-08:32:00.7697348608 INTERVAL-00.0000074375 =000171=
1-0000 02000000 00280800 001EE3C5 E2E3D7F0 F5401663 1BA501CD D1DC0002 18F0BA40 *..........TESTP05 ...v..J....0. *
0020 00000000 18F0CDB0 018D0004 *.....0...... *
2-0000 00DE6EC4 C6C8C4F2 D3D6E340 40404040 E7D7F0F5 184AC080 18DF2D78 18DCD030 *..>DFHD2LOT XP05.${.......}.*
0020 00000000 0006EFF0 00000000 18DF2E0C 18F0CDE0 00000000 00000000 FF6CD800 *.......0.........0.\.........%Q.*
0040 00000000 00000000 00000000 00000000 00000000 E3C5E2E3 D7F0F540 010C010C *....................TESTP05 ....*
0060 A000C000 00000000 00000000 00000000 C9E8D2F2 E9F2C7F1 B60AF030 A54A8EC0 *..{.............IYK2Z2G1..0.v$.{*
0080 D1E3C9D3 D3C9F140 40404040 40404040 00000000 00000000 C7C2C9C2 D4C9E8C1 *JTILLI1 ........GBIBMIYA*
00A0 C9E8C1D8 E3C3F0F3 0AF030A5 4A8EC6D9 C2400003 000118F0 CDE00000 00000000 *IYAQTC03.0.v$.FRB .....0.\......*
00C0 00000000 00000000 39050001 04000000 00000000 00000000 00000000 0000 *.............................. *
3-0000 00 *. *
4-0000 E2D8D3C3 C1404040 00000088 00000000 00004040 40404040 40404040 40404040 *SQLCA ...h...... *
0020 40404040 40404040 40404040 40404040 40404040 40404040 40404040 40404040 * *
0040 40404040 40404040 40404040 40404040 40404040 40404040 C4E2D540 40404040 * DSN *
0060 00000000 00000000 00000000 FFFFFFFF 00000000 00000000 40404040 40404040 *........................ *
0080 404040F0 F0F0F0F0 * 00000 *
5-0000 00C86EC4 C6C8C4F2 C5D5E340 40404040 E7D7F0F5 40404040 B60AF017 63D17AC6 *.H>DFHD2ENT XP05 ..0..J:F*
0020 E3C5E2E3 D7F0F540 00000000 00000000 00000000 00000000 D1E3C9D3 D3C9F140 *TESTP05 ................JTILLI1 *
0040 00808080 80000000 67E939C4 B0188B86 B60AF017 63D17AC6 0000000C 00000003 *.........Z.D...f..0..J:F........*
0060 00000001 00000001 00000000 00000000 00000001 00000001 00000000 00000000 *................................*
0080 00000000 00000002 00000001 00000000 00000000 00000000 00000000 00000000 *................................*
00A0 00000000 00000000 00000000 00000000 18DCD030 00000000 00000000 19044210 *..................}.............*
00C0 00000000 00000000 *........ *
6-0000 03006EC4 C6C8C4F2 C3E2C240 40404040 B60AF031 FAD0CB43 18D305E0 18DF2D78 *..>DFHD2CSB ..0..}...L.\....*
0020 19044210 007C6B90 00000000 00000000 B60AF030 A54A8EC0 00000000 00000000 *.....@,...........0.v$.{........*
0040 18DF2DE4 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *...U............................*
0060 00000000 00000000 00000000 E3C5E2E3 D7F0F540 D1E3C9D3 D3C9F140 40404040 *............TESTP05 JTILLI1 *
0080 40404040 C5D5E3D9 E7D7F0F5 F0F0F0F1 00000000 B60AF032 01359743 C7C2C9C2 * ENTRXP050001......0...p.GBIB*
00A0 D4C9E8C1 C9E8C1D8 E3C3F0F3 0AF030A5 4A8E0000 44800000 00000001 00000000 *MIYAIYAQTC03.0.v$...............*
00C0 00000000 00000000 00000000 40404040 40404040 40404040 40404040 FF6CD800 *............ .%Q.*
00E0 C6D9C240 00030001 18F0CDE0 00000000 00000000 00000000 00003905 00010400 *FRB .....0.\....................*
0100 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
0120 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
0140 00000000 00000000 00000000 00000000 00000000 00000000 98DCD110 00000000 *........................q.J.....*
0160 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
0180 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
01A0 00000000 00000000 40404040 40404040 40404040 40404040 40404040 40404040 *........ *
01C0 40404040 40404040 40404040 40404040 40404040 40404040 40404040 00000000 * ....*
01E0 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
0200 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
0220 00000000 00000000 00000000 00000000 00000000 00000000 00000005 18DCD2C0 *..............................K{*
0240 6E6EE399 81838540 E2A38199 A3406E6E 0100035C C9C4C5D5 00000000 00000000 *>>Trace Start >>...*IDEN........*
0260 0200035C E2C9C7D5 00000000 00000000 0300035C C3E3C8C4 00000000 00000000 *...*SIGN...........*CTHD........*
0280 0400035C C1D7C940 00000000 00000000 0500035C C1D7C940 00000000 00000000 *...*API ...........*API ........*
02A0 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
02C0 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
02E0 00000000 00000000 00000000 00000000 4C4CE399 81838540 C5958440 40404C4C *................<<Trace End <<*
AP 2523 ERM EVENT REGAINING-CONTROL-FROM-OPENAPI-TRUE(DSNCSQL )
TASK-00035 KE_NUM-003F TCB-L8000/007C6B90 RET-99902F92 TIME-08:32:00.7697405327 INTERVAL-00.0000056718 =000172=
1-0000 01 *. *
2-0000 C4E2D5C3 E2D8D340 *DSNCSQL *
3-0000 B60AF030 A54A8EC0 *..0.v$.{ *
4-0000 18CCB654 0006F004 19044204 00000000 007A8000 007A8000 18F0005C 18F0CCD0 *......0..........:...:...0.*.0.}*
0020 190441C0 19044210 19044206 18F000D0 19044200 18CCBCA0 190441C8 190441B0 *...{.........0.}...........H....*
0040 190441AC 190441EC 18CCB5F3 190441FD 18CCB5F4 190441B4 190441B2 00020000 *...........3.......4............*
5-0000 D3F8 *L8 *
AP 2521 ERM EXIT PLI-APPLICATION-CALL-TO-TRUE(DSNCSQL )
TASK-00035 KE_NUM-003F TCB-L8000/007C6B90 RET-99902F92 TIME-08:32:00.7697463608 INTERVAL-00.0000058281 =000173=
1-0000 01 *. *
2-0000 C4E2D5C3 E2D8D340 *DSNCSQL *
3-0000 B60AF030 A54A8EC0 *..0.v$.{ *
4-0000 E3C5E2E3 D7F0F540 00000001 00100000 19900000 999000E0 000114E0 00000000 *TESTP05 ............r..\...\....*
0020 00000020 00007BB0 00000000 98400000 0040000A 00101100 00000000 00000000 *......#.....q ... ..............*
0040 00000000 00000000 00000000 *............ *
The CSUB is the connection control block that CICS uses to manage, and exchange information about, a thread into DB2. It is the CICS equivalent to the DB2 connection control block. The CSUB is linked to the thread TCB that CICS uses to run the thread. See Overview: How CICS connects to DB2 for a full explanation of the relationship between the CSUB, the DB2 connection control block and the thread TCB.
When CICS is connected to DB2 Version 5 or earlier, the thread TCB is a subtask TCB owned by the CICS DB2 attachment facility and not known to the CICS dispatcher or kernel. This means that CICS tracing cannot be performed in the subtask program, DFHD2EX3. DFHD2EX3 does issue one GTF trace to record the point in time it posts back the CICS task on completion of the DB2 request. In addition to this, DFHD2EX3 maintains its own trace table at the end of the CSUB control block to record the requests it makes to DB2, and the responses to those requests.
When CICS is connected to DB2 Version 6 or later, and is using the open transaction environment, the thread TCB is an open TCB known to the CICS dispatcher and kernel. The CICS DB2 thread processor DFHD2D2, which replaces DFHD2EX3 in the open transaction environment, can therefore use CICS tracing. As well as using CICS tracing, DFHD2D2, like DFHD2EX3, maintains a trace table at the end of the CSUB control block to record the requests it makes to DB2, and the responses to those requests.
The CSUB trace table is 160 bytes in length allowing ten entries of 16 bytes to be written. The trace table wraps when all ten entries have been used. The format of each trace entry is shown in Table 16.
Bytes | Content | Information |
---|---|---|
Bytes 0-3 | Trace request number | Fullword number of the trace entry written.
The number is used to find the latest entry written. |
Bytes 4-7 | Trace request | Four-character representation of the DB2 request issued.
Possible values are:
ABRT - Abort request API - SQL or IFI request ASSO - Associate request COMM - Commit request CTHD - Create thread request DISS - Dissociate request ERRH - Error handler request IDEN - Identify request PREP - Prepare request PSGN - Partial signon request SIGN - Full signon request SYNC - Single phase request TERM - Terminate thread request TIDN - Terminate identify request TSGN - Terminate signon request *REC - Recovery routine entered |
Bytes 8-9 | reserved | |
Bytes 10-11 | frb return code | Two-byte frb return code |
Bytes 12-15 | frb reason code | Four-byte frb reason code |
The CSUB control block is formatted in a CICS system dump. It is also output if RI (RMI) level 2 trace is active in traces output from the CICS task-related user exit DFHD2EX1, plus all exception traces from DFHD2EX1.
In the trace example Figure 47, output when CICS is connected to DB2 Version 5 or earlier, DATA6 from trace point 3181 is the CSUB, and this section is shown in Figure 48. Looking at the character representation on the right hand side, the trace table is delimited by >>Trace Start >> and <<Trace End <<. In this example you can see that an identify, signon, create thread, followed by two API requests have been issued to DB2, and all requests were successful and the FRB return code and reason codes for each request are zeros.
6-0000 03006EC4 C6C8C4F2 C3E2C240 40404040 B60AF031 FAD0CB43 18D305E0 18DF2D78 *..>DFHD2CSB ..0..}...L.\....*
0020 19044210 007C6B90 00000000 00000000 B60AF030 A54A8EC0 00000000 00000000 *.....@,...........0.v$.{........*
0040 18DF2DE4 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *...U............................*
0060 00000000 00000000 00000000 E3C5E2E3 D7F0F540 D1E3C9D3 D3C9F140 40404040 *............TESTP05 JTILLI1 *
0080 40404040 C5D5E3D9 E7D7F0F5 F0F0F0F1 00000000 B60AF032 01359743 C7C2C9C2 * ENTRXP050001......0...p.GBIB*
00A0 D4C9E8C1 C9E8C1D8 E3C3F0F3 0AF030A5 4A8E0000 44800000 00000001 00000000 *MIYAIYAQTC03.0.v$...............*
00C0 00000000 00000000 00000000 40404040 40404040 40404040 40404040 FF6CD800 *............ .%Q.*
00E0 C6D9C240 00030001 18F0CDE0 00000000 00000000 00000000 00003905 00010400 *FRB .....0.\....................*
0100 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
0120 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
0140 00000000 00000000 00000000 00000000 00000000 00000000 98DCD110 00000000 *........................q.J.....*
0160 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
0180 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
01A0 00000000 00000000 40404040 40404040 40404040 40404040 40404040 40404040 *........ *
01C0 40404040 40404040 40404040 40404040 40404040 40404040 40404040 00000000 * ....*
01E0 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
0200 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
0220 00000000 00000000 00000000 00000000 00000000 00000000 00000005 18DCD2C0 *..............................K{*
0240 6E6EE399 81838540 E2A38199 A3406E6E 0100035C C9C4C5D5 00000000 00000000 *>>Trace Start >>...*IDEN........*
0260 0200035C E2C9C7D5 00000000 00000000 0300035C C3E3C8C4 00000000 00000000 *...*SIGN...........*CTHD........*
0280 0400035C C1D7C940 00000000 00000000 0500035C C1D7C940 00000000 00000000 *...*API ...........*API ........*
02A0 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
02C0 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
02E0 00000000 00000000 00000000 00000000 4C4CE399 81838540 C5958440 40404C4C *................<<Trace End <<*
Figure 49 shows the same situation when CICS is connected to DB2 Version 6 or later. In this example you can see that an identify, signon, and create thread have been issued to DB2. There is an API request, followed by a syncpoint and a dissociate (which dissociates the DB2 connection control block from the L8 TCB). The transaction now makes another API request, starting another unit of work, and the DB2 connection control block is reassociated (ASSO) with the L8 TCB. A partial signon occurs to create an accounting record for the previous unit of work. The API request is now issued to DB2.
5-0000 03006EC4 C6C8C4F2 C3E2C240 40404040 B6AD65D0 21D3EAC2 19335860 193F3D78 *..>DFHD2CSB ...}.L.B...-....*
0020 1956D210 007C9A60 00000000 00000000 B6AD65D2 9A2090C6 00000000 00000000 *..K.@.-...........K...F........*
0040 193F3DE4 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *...U............................*
0060 00000000 00000000 00000000 E3C5E2E3 D7F0F540 D1E3C9D3 D3C9F140 40404040 *............TESTP05 JTILLI1 *
0080 40404040 C5D5E3D9 E7D7F0F5 F0F0F0F1 00000000 B6AD65D0 287EBD02 C7C2C9C2 * ENTRXP050001.......}.=..GBIB*
00A0 D4C9E8C1 C9E8C3E7 E3C3F0F7 AD65CE96 02B68000 44800000 00000001 D1E3C9D3 *MIYAIYCXTC07...o............JTIL*
00C0 D3C9F140 40404040 40404040 40404040 40404040 40404040 40404040 FF6D6400 *LI1 ._..*
00E0 C6D9C240 00030001 1940CDF0 00000000 00000000 00000000 00004005 00010000 *FRB ..... .0.............. .....*
0100 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
0120 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
0140 00000000 00000000 00000000 00000000 00000000 00000000 9954B110 00000000 *........................r.......*
0160 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
0180 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
01A0 00000000 00000000 40404040 40404040 40404040 40404040 40404040 40404040 *........ *
01C0 40404040 40404040 40404040 40404040 40404040 40404040 40404040 00000000 * ....*
01E0 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
0200 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *................................*
0220 00000000 00000000 00000000 00000000 00000000 00000000 00000009 1954B300 *................................*
0240 6E6EE399 81838540 E2A38199 A3406E6E 0100057C C9C4C5D5 00000000 00000000 *>>Trace Start >>...@IDEN........*
0260 0200057C E2C9C7D5 00000000 00000000 0300057C C3E3C8C4 00000000 00000000 *...@SIGN...........@CTHD........*
0280 0400057C C1D7C940 00000000 00000000 0500057C E2E8D5C3 00000000 00000000 *...@API ...........@SYNC........*
02A0 0600057C C4C9E2E2 00000000 00000000 0700057C C1E2E2D6 00000000 00000000 *...@DISS...........@ASSO........*
02C0 0800057C D7E2C7D5 00000000 00000000 0900057C C1D7C940 00000000 00000000 *...@PSGN...........@API ........*
02E0 00000000 00000000 00000000 00000000 4C4CE399 81838540 C5958440 40404C4C *................<
02E0 00000000 00000000 00000000 00000000 4C4CE399 81838540 C5958440 40404C4C *................<
If a CICS-DB2 subtask abends, part of the recovery process is to save information from the MVS™ SDWA in the CSUB control block, for example CSB_SDWA_REGS (regs 0 - 15) and CSB_SDWA_PSW. Although the CSUB is typically freemained following the failure, the exception trace written at the time of failure (AP 319D) captures the CSUB control block containing the SDWA information.