D2GDS - CICS/DB2 Global statistics

    CONTROL BLOCK NAME = DFHD2GDS
    NAME OF MATCHING PLS CONTROL BLOCK = DFHD2GPS
    DESCRIPTIVE NAME = CICS TS DB2 Global statistics
           Licensed Materials - Property of IBM
            Restricted Materials of IBM 
           5655-Y04
           (C) Copyright IBM Corp. 1997, 2009 
    FUNCTION =
           This dsect describes the CICS/DB2 statistics provided by
           the CICS/DB2 Attachment facility.
           A single record will be built to respond to a request for
           DB2CONN statistics.
    LIFETIME =
           The statistics record is created when a global statistics
           request is received. Storage for the data block is released
           when the user task is detached.
    STORAGE CLASS =
    LOCATION =
           The user is passed a pointer to the head of the storage
           block.
    INNER CONTROL BLOCKS = none
    NOTES :
       DEPENDENCIES = S/370
       RESTRICTIONS = none
       MODULE TYPE = Domain call buffer
   --------------------------------------------------------------------
    EXTERNAL REFERENCES = none
        DATA AREAS = none
        CONTROL BLOCKS = from CICS/DB2 Attachment Facility.
        GLOBAL VARIABLES (Macro pass) = none
   --------------------------------------------------------------------
    ALTHOUGH PROVIDED IN A GENERAL INTERFACE LIBRARY DFHD2GDS IS
    NOT TO BE USED AS A GENERAL PROGRAMMING INTERFACE. REFER TO
    PRODUCT DOCUMENTATION TO DETERMINE INTENDED USAGE.
Table 1.
Offset Hex Type Len Name (Dim) Description
(0) STRUCTURE 0 DFHD2GDS CICS/DB2 Global statistics
(0) FULLWORD 4 (0) fullword alignment
(0) HALFWORD 2 D2GLEN Length of data area
(0) .11. .11.   D2GIDE "0102" CICS/DB2 global stats id mask
(2) ADDRESS 2 D2GID CICS/DB2 global stats id
(2) .... ...1   D2GVERS "X'01'" Stats version number id mask
(4) CHARACTER 1 D2GDVERS Stats version number
(5) CHARACTER 3   Filler
(8) FULLWORD 4 D2G_GLOBAL_STATS (0) global stats
(8) CHARACTER 8 D2G_DB2CONN_NAME name of the DB2CONN
(10) CHARACTER 4 D2G_DB2_ID DB2 sysid
(14) CHARACTER 4 D2G_DB2_RELEASE release of DB2
(18) CHARACTER 8 D2G_CONNECT_TIME_GMT connect time (GMT)
(20) CHARACTER 8 D2G_CONNECT_TIME_ LOCAL connect time (local)
(28) CHARACTER 8 D2G_DISCONNECT_TIME_ GMT disconnect time (GMT)
(30) CHARACTER 8 D2G_DISCONNECT_TIME_ LOCAL discconnect time (local)
(38) FULLWORD 4 D2G_TCB_LIMIT max number of TCBs
(3C) FULLWORD 4 D2G_TCB_CURRENT current number of TCBs
(40) FULLWORD 4 D2G_TCB_HWM HWM of TCBs
(44) FULLWORD 4 D2G_TCB_FREE current number of free TCBs
(48) FULLWORD 4 D2G_TCB_READYQ_ CURRENT number of tasks on TCB readyq
(4C) FULLWORD 4 D2G_TCB_READYQ_HWM peak number of tasks on TCB readyq
(50) CHARACTER 4 D2G_DB2_GROUP_ID DB2 group id
(54) BITSTRING 1 D2G_RESYNCMEMBER resync uow's
(55) CHARACTER 3   reserved
(58) FULLWORD 4 D2G_REUSELIMIT Thread reuse limit
(5C) CHARACTER 28   reserved
(78) FULLWORD 4 D2G_POOL_STATS (0) pool statistics
(78) CHARACTER 8 D2G_POOL_PLAN_NAME static plan name if any
(80) CHARACTER 8 D2G_POOL_PLANEXIT_ NAME planexit name if any
(88) CHARACTER 8 D2G_POOL_AUTHID static authid if any
(90) BITSTRING 1 D2G_POOL_AUTHTYPE authtype if any
(91) BITSTRING 1 D2G_POOL_ACCOUNTREC Accountrec setting
(92) BITSTRING 1 D2G_POOL_THREADWAIT Threadwait setting
(93) BITSTRING 1 D2G_POOL_PRIORITY thread priority
(94) FULLWORD 4 D2G_POOL_CALLS number of calls using pool
(98) FULLWORD 4 D2G_POOL_SIGNONS number of signons
(9C) FULLWORD 4 D2G_POOL_COMMITS number of commits
(A0) FULLWORD 4 D2G_POOL_ABORTS number of aborts
(A4) FULLWORD 4 D2G_POOL_SINGLE_PHASE number of single phase commits
(A8) FULLWORD 4 D2G_POOL_THREAD_REUSE number of thread reuses
(AC) FULLWORD 4 D2G_POOL_THREAD_TERM number of thread terminates
(B0) FULLWORD 4 D2G_POOL_THREAD_WAITS number of thread waits
(B4) FULLWORD 4 D2G_POOL_THREAD_LIMIT maximum number of threads
(B8) FULLWORD 4 D2G_POOL_THREAD_ CURRENT current number of threads
(BC) FULLWORD 4 D2G_POOL_THREAD_HWM peak number of threads
(C0) FULLWORD 4 D2G_POOL_TASK_CURRENT current number of tasks
(C4) FULLWORD 4 D2G_POOL_TASK_HWM peak number of tasks
(C8) FULLWORD 4 D2G_POOL_TASK_TOTAL total number of tasks
(CC) FULLWORD 4 D2G_POOL_READYQ_ CURRENT number of tasks on ready queue
(D0) FULLWORD 4 D2G_POOL_READYQ_HWM peak number of tasks on ready queue
(D4) FULLWORD 4 D2G_POOL_PARTIAL_ SIGNONS number of partial signons
(D8) FULLWORD 4 D2G_POOL_THREAD_ CREATE number of thread creates
(DC) FULLWORD 4 D2G_POOL_REUSELIMIT_ COUNT number of times hit reuselimit
(E0) CHARACTER 16   reserved
(F0) FULLWORD 4 D2G_COMMAND_STATS (0) DSNC command statistics
(F0) CHARACTER 8 D2G_COMD_AUTHID static authid if any
(F8) BITSTRING 1 D2G_COMD_AUTHTYPE authtype if any
(F9) CHARACTER 3   reserved
(FC) FULLWORD 4 D2G_COMD_CALLS number of dsnc comd calls
(100) FULLWORD 4 D2G_COMD_SIGNONS number of signons
(104) FULLWORD 4 D2G_COMD_THREAD_TERM number of thread terminates
(108) FULLWORD 4 D2G_COMD_THREAD_OVERF number of overflows to pool
(10C) FULLWORD 4 D2G_COMD_THREAD_LIMIT maximum number of threads
(110) FULLWORD 4 D2G_COMD_THREAD_ CURRENT current number of threads
(114) FULLWORD 4 D2G_COMD_THREAD_HWM peak number of threads
(118) FULLWORD 4 D2G_COMD_THREAD_ CREATE number of thread creates
(11C) CHARACTER 32   reserved
(13C) CHARACTER 8 D2G_DB2CONN_DEFINE_ SOURCE Group installed from
(144) BITSTRING 8 D2G_DB2CONN_CHANGE_ TIME Change/create time
(14C) CHARACTER 8 D2G_DB2CONN_CHANGE_ USERID Change userid
(154) BITSTRING 2 D2G_DB2CONN_CHANGE_ AGENT Change agent
(156) BITSTRING 2 D2G_DB2CONN_INSTALL_ AGENT Install agent
(158) BITSTRING 8 D2G_DB2CONN_INSTALL_ TIME Install/Create time
(160) CHARACTER 8 D2G_DB2CONN_INSTALL_ USERID Install userid
(168) BITSTRING 4   Reserved
(168) 0 D2G_END "*"
(168) 0 D2G_LENGTH "*-D2GLEN" Length of dsect 
  Equates to test D2G_RESYNCMEMBER
(168) .... ....   D2G_RESYNCMEMBER_ RESYNC "0" Resync uow's
(168) .... ...1   D2G_RESYNCMEMBER_ NORESYNC "1" Noresync uow's 
  Equates to test D2G_POOL_AUTHTYPE and D2G_COMD_AUTHTYPE
(168) .... ....   D2G_AUTHTYPE_NA "0" Not applicable
(168) .... ...1   D2G_AUTHTYPE_USERID "1" Authtype(userid)
(168) .... ..1.   D2G_AUTHTYPE_OPID "2" Authtype(opid)
(168) .... ..11   D2G_AUTHTYPE_GROUP "3" Authtype(group)
(168) .... .1..   D2G_AUTHTYPE_SIGNID "4" Authtype(signid)
(168) .... .1.1   D2G_AUTHTYPE_TERM "5" Authtype(term)
(168) .... .11.   D2G_AUTHTYPE_TXID "6" Authtype(txid) 
  Equates to test D2G_POOL_ACCOUNTREC
(168) .... ...1   D2G_ACCOUNTREC_NONE "1" Accountrec(none)
(168) .... ..1.   D2G_ACCOUNTREC_TXID "2" Accountrec(txid)
(168) .... ..11   D2G_ACCOUNTREC_TASK "3" Accountrec(task)
(168) .... .1..   D2G_ACCOUNTREC_UOW "4" Accountrec(uow) 
  Equates to test D2G_POOL_THREADWAIT
(168) .... ...1   D2G_THREADWAIT_YES "1" Threadwait(yes)
(168) .... ..1.   D2G_THREADWAIT_NO "2" Threadwait(no) 
  Equates to test D2G_POOL_PRIORITY
(168) .... ....   D2G_PRIORITY_NA "0" Not applicable
(168) .... ...1   D2G_PRIORITY_HIGH "1" Priority(high)
(168) .... ..1.   D2G_PRIORITY_EQUAL "2" Priority(equal)
(168) .... ..11   D2G_PRIORITY_LOW "3" Priority(low) 
  Equates to test D2G_DB2CONN_CHANGE_AGENT
(168) .... ...1   D2G_DB2CONN_CSDAPI_ CHANGE "X'01'" Change Agent - CSD API
(168) .... ..1.   D2G_DB2CONN_ CSDBATCH_CHANGE "X'02'" Change Agent - DFHCSDUP
(168) .... ..11   D2G_DB2CONN_DREPAPI_ CHANGE "X'03'" Change Agent - DREP API
(168) .... .1..   D2G_DB2CONN_CREATE_ CHANGE "X'04'" Change Agent - CREATE SPI 
  Equates to test D2G_DB2CONN_INSTALL_AGENT
(168) .... ...1   D2G_DB2CONN_CSDAPI_ INSTALL "X'01'" Install Agent - CSD API
(168) .... .1..   D2G_DB2CONN_CREATE_ INSTALL "X'04'" Install Agent - CREATE SPI
(168) .... .1.1   D2G_DB2CONN_GRPLIST_ INSTALL "X'05'" Install Agent - GRPLIST