Trace for CICS DB2

In releases of CICS® before CICS Transaction Server for OS/390®, Version 1 Release 2, the user could specify the trace points to be used by the CICS DB2® attachment facility using parameters in the RCT. Trace points can no longer be user specified. The CICS DB2 attachment facility uses AP domain trace points in the range 3100 to 33FF. The contents of all trace points issued by the CICS DB2 attachment facility are documented in CICS Trace Entries.

Standard tracing performed by the CICS DB2 attachment facility is controlled by the FC (File Control) and RI (RMI) trace flags. RMI trace controls:

All other standard tracing from the attachment is controlled using File Control tracing. A large proportion of the possible trace issued from the CICS DB2 attachment facility is exception tracing which is output irrespective of RI or FC tracing being active, but is issued independently. The levels of FC and RI trace required can be set using the CICS-supplied transaction, CETR, or using SIT parameters STNTRFC= and STNTRRI=.

Figure 46 and Figure 47 show examples of the trace output from the RMI and the CICS DB2 task-related user exit, DFHD2EX1, when level 1 and level 2 RI tracing is active. In both examples, the trace shows one SQL statement being executed. The example trace in Figure 46 was output when CICS was connected to DB2 Version 5 or earlier. In this environment, the CICS DB2 task-related user exit runs on the CICS QR TCB (the main TCB), and creates subtask TCBs to run threads into DB2. The example trace in Figure 47 was output when CICS was connected to DB2 Version 6, and was using the open transaction environment. In this environment, the CICS DB2 task-related user exit runs on an open L8 mode TCB, and uses that same TCB to run threads into DB2.

CICS DB2 trace output is written to the CICS internal trace table and auxiliary trace and GTF trace destinations if active.

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

The example trace in Figure 47 was produced when CICS was connected to DB2 Version 6.

Figure 47. Sample trace output from the RMI and the CICS DB2 TRUE -- CICS connected to DB2 Version 6 or later
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                                                *............                    *

CSUB trace

The CSUB is the connection control block that CICS uses to manage, and exchange information about, a thread into DB2. It is the CICS equivalent to the DB2 connection control block. The CSUB is linked to the thread TCB that CICS uses to run the thread. See Overview: How CICS connects to DB2 for a full explanation of the relationship between the CSUB, the DB2 connection control block and the thread TCB.

When CICS is connected to DB2 Version 5 or earlier, the thread TCB is a subtask TCB owned by the CICS DB2 attachment facility and not known to the CICS dispatcher or kernel. This means that CICS tracing cannot be performed in the subtask program, DFHD2EX3. DFHD2EX3 does issue one GTF trace to record the point in time it posts back the CICS task on completion of the DB2 request. In addition to this, DFHD2EX3 maintains its own trace table at the end of the CSUB control block to record the requests it makes to DB2, and the responses to those requests.

When CICS is connected to DB2 Version 6 or later, and is using the open transaction environment, the thread TCB is an open TCB known to the CICS dispatcher and kernel. The CICS DB2 thread processor DFHD2D2, which replaces DFHD2EX3 in the open transaction environment, can therefore use CICS tracing. As well as using CICS tracing, DFHD2D2, like DFHD2EX3, maintains a trace table at the end of the CSUB control block to record the requests it makes to DB2, and the responses to those requests.

The CSUB trace table is 160 bytes in length allowing ten entries of 16 bytes to be written. The trace table wraps when all ten entries have been used. The format of each trace entry is shown in Table 16.

Table 16. Layout of CSUB trace table entry
Bytes Content Information
Bytes 0-3 Trace request number Fullword number of the trace entry written.
The number is used to find the latest entry written.
Bytes 4-7 Trace request Four-character representation of the DB2 request issued. Possible values are:
ABRT - Abort request
API - SQL or IFI request
ASSO - Associate request
COMM - Commit request
CTHD - Create thread request
DISS - Dissociate request
ERRH - Error handler request
IDEN - Identify request
PREP - Prepare request
PSGN - Partial signon request
SIGN - Full signon request
SYNC - Single phase request
TERM - Terminate thread request
TIDN - Terminate identify request
TSGN - Terminate signon request
*REC - Recovery routine entered
Bytes 8-9 reserved
Bytes 10-11 frb return code Two-byte frb return code
Bytes 12-15 frb reason code Four-byte frb reason code

The CSUB control block is formatted in a CICS system dump. It is also output if RI (RMI) level 2 trace is active in traces output from the CICS task-related user exit DFHD2EX1, plus all exception traces from DFHD2EX1.

In the trace example Figure 47, output when CICS is connected to DB2 Version 5 or earlier, DATA6 from trace point 3181 is the CSUB, and this section is shown in Figure 48. Looking at the character representation on the right hand side, the trace table is delimited by >>Trace Start >> and <<Trace End <<. In this example you can see that an identify, signon, create thread, followed by two API requests have been issued to DB2, and all requests were successful and the FRB return code and reason codes for each request are zeros.

Figure 48. Sample CSUB trace -- CICS connected to DB2 Version 5 or earlier
                6-0000  03006EC4 C6C8C4F2 C3E2C240 40404040  B60AF031 FAD0CB43 18D305E0 18DF2D78  *..>DFHD2CSB     ..0..}...L.\....*
                  0020  19044210 007C6B90 00000000 00000000  B60AF030 A54A8EC0 00000000 00000000  *.....@,...........0.v$.{........*
                  0040  18DF2DE4 00000000 00000000 00000000  00000000 00000000 00000000 00000000  *...U............................*
                  0060  00000000 00000000 00000000 E3C5E2E3  D7F0F540 D1E3C9D3 D3C9F140 40404040  *............TESTP05 JTILLI1     *
                  0080  40404040 C5D5E3D9 E7D7F0F5 F0F0F0F1  00000000 B60AF032 01359743 C7C2C9C2  *    ENTRXP050001......0...p.GBIB*
                  00A0  D4C9E8C1 C9E8C1D8 E3C3F0F3 0AF030A5  4A8E0000 44800000 00000001 00000000  *MIYAIYAQTC03.0.v$...............*
                  00C0  00000000 00000000 00000000 40404040  40404040 40404040 40404040 FF6CD800  *............                .%Q.*
                  00E0  C6D9C240 00030001 18F0CDE0 00000000  00000000 00000000 00003905 00010400  *FRB .....0.\....................*
                  0100  00000000 00000000 00000000 00000000  00000000 00000000 00000000 00000000  *................................*
                  0120  00000000 00000000 00000000 00000000  00000000 00000000 00000000 00000000  *................................*
                  0140  00000000 00000000 00000000 00000000  00000000 00000000 98DCD110 00000000  *........................q.J.....*
                  0160  00000000 00000000 00000000 00000000  00000000 00000000 00000000 00000000  *................................*
                  0180  00000000 00000000 00000000 00000000  00000000 00000000 00000000 00000000  *................................*
                  01A0  00000000 00000000 40404040 40404040  40404040 40404040 40404040 40404040  *........                        *
                  01C0  40404040 40404040 40404040 40404040  40404040 40404040 40404040 00000000  *                            ....*
                  01E0  00000000 00000000 00000000 00000000  00000000 00000000 00000000 00000000  *................................*
                  0200  00000000 00000000 00000000 00000000  00000000 00000000 00000000 00000000  *................................*
                  0220  00000000 00000000 00000000 00000000  00000000 00000000 00000005 18DCD2C0  *..............................K{*
                  0240  6E6EE399 81838540 E2A38199 A3406E6E  0100035C C9C4C5D5 00000000 00000000  *>>Trace Start >>...*IDEN........*
                  0260  0200035C E2C9C7D5 00000000 00000000  0300035C C3E3C8C4 00000000 00000000  *...*SIGN...........*CTHD........*
                  0280  0400035C C1D7C940 00000000 00000000  0500035C C1D7C940 00000000 00000000  *...*API ...........*API ........*
                  02A0  00000000 00000000 00000000 00000000  00000000 00000000 00000000 00000000  *................................*
                  02C0  00000000 00000000 00000000 00000000  00000000 00000000 00000000 00000000  *................................*
                  02E0  00000000 00000000 00000000 00000000  4C4CE399 81838540 C5958440 40404C4C  *................<<Trace End   <<*
 
 

Figure 49 shows the same situation when CICS is connected to DB2 Version 6 or later. In this example you can see that an identify, signon, and create thread have been issued to DB2. There is an API request, followed by a syncpoint and a dissociate (which dissociates the DB2 connection control block from the L8 TCB). The transaction now makes another API request, starting another unit of work, and the DB2 connection control block is reassociated (ASSO) with the L8 TCB. A partial signon occurs to create an accounting record for the previous unit of work. The API request is now issued to DB2.

Figure 49. Sample CSUB trace -- CICS connected to DB2 Version 6 or later
                5-0000  03006EC4 C6C8C4F2 C3E2C240 40404040  B6AD65D0 21D3EAC2 19335860 193F3D78  *..>DFHD2CSB     ...}.L.B...-....*
                  0020  1956D210 007C9A60 00000000 00000000  B6AD65D2 9A2090C6 00000000 00000000  *..K.@.-...........K...F........*
                  0040  193F3DE4 00000000 00000000 00000000  00000000 00000000 00000000 00000000  *...U............................*
                  0060  00000000 00000000 00000000 E3C5E2E3  D7F0F540 D1E3C9D3 D3C9F140 40404040  *............TESTP05 JTILLI1     *
                  0080  40404040 C5D5E3D9 E7D7F0F5 F0F0F0F1  00000000 B6AD65D0 287EBD02 C7C2C9C2  *    ENTRXP050001.......}.=..GBIB*
                  00A0  D4C9E8C1 C9E8C3E7 E3C3F0F7 AD65CE96  02B68000 44800000 00000001 D1E3C9D3  *MIYAIYCXTC07...o............JTIL*
                  00C0  D3C9F140 40404040 40404040 40404040  40404040 40404040 40404040 FF6D6400  *LI1                         ._..*
                  00E0  C6D9C240 00030001 1940CDF0 00000000  00000000 00000000 00004005 00010000  *FRB ..... .0.............. .....*
                  0100  00000000 00000000 00000000 00000000  00000000 00000000 00000000 00000000  *................................*
                  0120  00000000 00000000 00000000 00000000  00000000 00000000 00000000 00000000  *................................*
                  0140  00000000 00000000 00000000 00000000  00000000 00000000 9954B110 00000000  *........................r.......*
                  0160  00000000 00000000 00000000 00000000  00000000 00000000 00000000 00000000  *................................*
                  0180  00000000 00000000 00000000 00000000  00000000 00000000 00000000 00000000  *................................*
                  01A0  00000000 00000000 40404040 40404040  40404040 40404040 40404040 40404040  *........                        *
                  01C0  40404040 40404040 40404040 40404040  40404040 40404040 40404040 00000000  *                            ....*
                  01E0  00000000 00000000 00000000 00000000  00000000 00000000 00000000 00000000  *................................*
                  0200  00000000 00000000 00000000 00000000  00000000 00000000 00000000 00000000  *................................*
                  0220  00000000 00000000 00000000 00000000  00000000 00000000 00000009 1954B300  *................................*
                  0240  6E6EE399 81838540 E2A38199 A3406E6E  0100057C C9C4C5D5 00000000 00000000  *>>Trace Start >>...@IDEN........*
                  0260  0200057C E2C9C7D5 00000000 00000000  0300057C C3E3C8C4 00000000 00000000  *...@SIGN...........@CTHD........*
                  0280  0400057C C1D7C940 00000000 00000000  0500057C E2E8D5C3 00000000 00000000  *...@API ...........@SYNC........*
                  02A0  0600057C C4C9E2E2 00000000 00000000  0700057C C1E2E2D6 00000000 00000000  *...@DISS...........@ASSO........*
                  02C0  0800057C D7E2C7D5 00000000 00000000  0900057C C1D7C940 00000000 00000000  *...@PSGN...........@API ........*
                  02E0  00000000 00000000 00000000 00000000  4C4CE399 81838540 C5958440 40404C4C  *................<
                  02E0  00000000 00000000 00000000 00000000  4C4CE399 81838540 C5958440 40404C4C  *................<
 

CSUB Abend information

If a CICS-DB2 subtask abends, part of the recovery process is to save information from the MVS™ SDWA in the CSUB control block, for example CSB_SDWA_REGS (regs 0 - 15) and CSB_SDWA_PSW. Although the CSUB is typically freemained following the failure, the exception trace written at the time of failure (AP 319D) captures the CSUB control block containing the SDWA information.

Related concepts
Problem determination for CICS DB2
Thread TCBs (task control blocks)
Wait types for CICS DB2
Messages for CICS DB2
Dump for CICS DB2
DB2 thread identification
Transaction abend codes for CICS DB2
Execution Diagnostic Facility (EDF) for CICS DB2
Handling deadlocks in the CICS DB2 environment
[[ Contents Previous Page | Next Page Index ]]