Trace for CICS DB2
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 DB2 trace points.
- Trace output from the CICS DB2 task-related user exit, DFHD2EX1
- Trace output from the CICS DB2 attach module, DFHD2D2 (when CICS is connected to DB2 Version 6 or later)
- GTF trace from the CICS DB2 subtask program DFHD2EX3 (when CICS is connected to DB2 Version 5 or earlier).
Sample trace output from the RMI and the CICS DB2 TRUE — CICS connected to DB2 Version 5 or earlier and Sample trace output from the RMI and the CICS DB2 TRUE — CICS connected to DB2 Version 6 or later 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 Sample trace output from the RMI and the CICS DB2 TRUE — CICS connected to DB2 Version 5 or earlier 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 Sample trace output from the RMI and the CICS DB2 TRUE — CICS connected to DB2 Version 6 or later 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.
Sample trace output from the RMI and the CICS DB2 TRUE — CICS connected to DB2 Version 5 or earlier
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 *............ *
Sample trace output from the RMI and the CICS DB2 TRUE — CICS connected to DB2 Version 6 or later
This example trace 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 *............ *