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.

Standard tracing performed by the CICS DB2 attachment facility is controlled by the RA (Resource Manager Adapter) and RI (RMI) trace flags. RMI trace controls:
  • 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).
All other standard tracing from the attachment is controlled using Resource Manager Adapter 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 RA tracing being active, but is issued independently. The levels of RA and RI trace required can be set using the CICS-supplied transaction, CETR, or using SIT parameters STNTRRA= and STNTRRI=.

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


dfhtk2p.html | Timestamp icon Last updated: Monday, 5 June 2017