DBCTL statistics

DBCTL supplies CICS® with statistics information when CICS disconnects from DBCTL. These statistics are known as unsolicited statistics, because they are not produced as part of normal internal processing, but are produced as a z/OS® UNIX System Services statistics record. The statistics are written to SMF regardless of the status of statistics recording.

CICS-DBCTL statistics are collected whenever DBCTL is disconnected as a result of:
  • An orderly or immediate disconnection of DBCTL
  • An orderly termination of CICS

CICS-DBCTL statistics are not collected if there is an immediate shutdown or abend of CICS.

When statistics are collected, the following actions occur:
  1. The DRA returns statistics for the CICS-DBCTL session that has ended to DFHDBAT.
  2. DFHDBAT invokes the CICS statistics exit for DBCTL statistics (DFHDBSTX).
  3. DFHDBSTX invokes the CICS statistics domain.
  4. The CICS statistics domain writes the statistics to the SMF data set.
CICS-DBCTL session statistics are contained in the DFHDBUDS DSECT, which you can generate from the copybook DFHDBUDS. DFHDBUDS includes the following information, which is returned from the DRA for that CICS session:
  • DBCTL identifier for the CICS-DBCTL session (STATDBID).
  • DBCTL recoverable service element (RSE) name (STARSEN). For more information about RSEs, see Recovery and restart operations for DBCTL.
  • Time CICS connected to DBCTL (STACTIME).
  • Time CICS disconnected from DBCTL (STADTIME).
  • Minimum number of threads specified in the DRA startup table (STAMITHD).
  • Maximum number of threads specified in the DRA startup table (STAMATHD).
  • Number of times that the CICS-DBCTL session collapsed threads down to the minimum thread value specified in the DRA startup table (STANOMITHD).
  • Number of times that the CICS-DBCTL session reached the maximum thread value specified in the DRA startup table (STANOMATHD).
  • Elapsed time, expressed in hours, minutes, and seconds, for which the CICS-DBCTL session ran at the maximum thread value (STAELMAX).
  • Peak number (also known as the high-water mark) of thread TCBs created throughout the CICS-DBCTL session (STAHIWAT).
  • Total number of times this CICS-DBCTL session successfully scheduled a PSB (STAPSBSU).

For information about DBCTL statistics, see DBCTL session termination statistics.

To extract and print a report from these statistics, run the CICS-supplied statistics utility program (DFHSTUP), specifying the specific APPLID of the relevant CICS system. The output includes CICS-DBCTL session statistics provided DBCTL was connected to CICS when the statistics were collected. For information about other parameters needed to run DFHSTUP, and a sample job stream you can use, see Statistics utility program (DFHSTUP). Figure 1 shows an example of a report produced by running DFHSTUP.
Figure 1. Example of CICS-DBCTL session statistics output
Unsolicited Statistics Report      Collection Date-Time 09/16/93-15:16:18  Last Reset 15:06:46
----------------------------------------------------------------------------------------------
DBCTL SESSION TERMINATION STATISTICS
------------------------------------
  CICS DBCTL Session Number           :             2
    DBCTL identifier                  :          SYS2
    DBCTL RSE name                    :      DBCTLSY2
    Time CICS connected to DBCTL      : 15:14:02.8506
    Time CICS disconnected from DBCTL : 15:16:18.3689
    Minimum number of threads         :             1
    Maximum number of threads         :             3
    Times minimum threads hit         :             1
    Times maximum threads hit         :             1
    Elapsed time at maximum threads   : 00:00:09.4371
    Peak number of thread TCBs        :             3
    Successful PSB schedules          :             9
Note: The statistics report produced by running DFHSTUP (shown in Figure 1) displays the times when CICS connected to and disconnected from DBCTL in hours, minutes, and seconds (hhmmss) format in local time. The DBCTL z/OS UNIX System Services record that is mapped by the DFHDBUDS DSECT contains the connect and disconnect times as four 8-byte store clock (STCK) values. These values are as follows:
  • Connect and disconnect time expressed in local time.
  • Connect and disconnect time expressed in Greenwich Mean Time (GMT).

CICS statistics that contain the number of DL/I requests by type that are issued against each DL/I database are not produced by CICS in the DBCTL environment. Instead, DBCTL produces this type of information. You can obtain DBCTL buffer pool utilization information from the DBCTL /DISPLAY command, or from the IMS log records of type X'45'.