Dump for CICS DB2

Control blocks from the CICS® DB2® attachment facility are formatted out in a CICS system dump under the control of the DB2 keyword of the CICS IPCS verbexit. The DB2 keyword may specify the following values:

In a CICS transaction dump, no summary or control blocks appear but the trace table contains the CICS DB2 trace entries.

A sample showing CICS DB2 summary information from a CICS system dump is shown in Figure 50. It gives information on the global state of the CICS DB2 connection, and a summary of transactions (under the headings "Tran id", "Task num", "TcaAddr", "TieAddr", "LotAddr", "Rctename", "RcteAddr", "CsubAddr", "Correlation id", "Uowid", "Subtask running", and "TCB in DB2"). This sample was output when CICS was connected to DB2 Version 6, so using the open transaction environment.

Figure 50. Dump example
===DB2: CICS/DB2 - SUMMARY
==DB2: GLOBAL STATE SUMMARY
   Db2conn name:                             RCTJT
   Connection status:                        Connected
   In standby mode:                          No
   DB2 id:                                   DE2D
   DB2 Group id:                                 
   DB2 release:                              0610
   Operating in OpenAPI mode:                Yes
   Service task started:                     Yes
   Master subtask started:                   No - not required
   Tcb limit:                                12
   Currently active tcbs:                    2
   Message Queue1:                           CDB2
   Message Queue2:
   Message Queue3:
   Statistics Queue:                         CDB2
   Standbymode:                              Reconnect
   Connecterror:                             Sqlcode
==DB2: TRANSACTION SUMMARY
Tran Task  TcaAddr  TieAddr  LotAddr  Rctename RcteAddr CsubAddr Correlation  Uowid            Subtask  TCB
id   num                                                         id                            running  in DB2
--------------------------------------------------------------------------------------------------------------
XP05 00050 184AB680 190442F0 19044370 XP05     18DF2D78 18D10330 ENTRXP050002 B60A17A16316E1C7 N/A      Yes
XP05 00048 184AC680 19044190 19044210 XP05     18DF2D78 18D10030 ENTRXP050001 B60A1794A7A9E7C4 N/A      No
 

Related concepts
Problem determination for CICS DB2
Thread TCBs (task control blocks)
Wait types for CICS DB2
Messages for CICS DB2
Trace 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 ]]