Data available for a CICS-DBCTL system

As with your CICS® or IMS™ system, observing the performance of DBCTL involves collecting and interpreting data gathered by various CICS and IMS performance tools. The difference with DBCTL is that you need to keep an eye on events taking place in separate address spaces. Figure 48 gives an overview of where DBCTL monitoring and statistics data is sent to and the tools you can use to produce output from this data. The data and tools mentioned are described in the sections that follow.

Figure 48. Overview of DBCTL statistics and monitoring data
 This figure summarizes where DBCTL monitoring and statistics data is sent and the tools that can produce output. DBCTL data is sent to:   The IMS log, as X'07', X'08', and X'45' records; The IMS monitor data set, where it can be processed by the DFSUTR20 utility into IMS monitor output; CICS, via the DRA.CICS sends the data it has received from DBCTL to SMF, which sends it to:   DFHMNDUP, from which it can go to DFH$MOLS to be issued as CICS monitoring facility reports; DFHSTUP, to be issued as CICS statistical reports; RMF to be issued as RMF reports; RMF to be issued as SLR output.

DBCTL statistics

DBCTL supplies CICS with statistics information when CICS disconnects from DBCTL. These are known as unsolicited statistics, because they are not produced as part of normal internal processing, but are produced as a USS 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:

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

When statistics are collected, the following happens:

  1. The DRA returns statistics for the CICS-DBCTL session that has just 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:

For information on DBCTL statistics see the CICS Performance Guide.

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 will include 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 the CICS Operations and Utilities Guide. Figure 49 shows an example of a report produced by running DFHSTUP.

Figure 49. Example of CICS-DBCTL session statistics output
Unsolicited Statistics Report      Collection Date-Time 09/16/93-15:16:18  Last Reset 15:06:46  Applid IYAHZCD2  Jobname CI13JTD5
---------------------------------------------------------------------------------------------------------------------------------
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 49) displays the times at which CICS connected to and disconnected from DBCTL in hours, minutes, and seconds (hhmmss) format in local time. The DBCTL USS record mapped by the DFHDBUDS DSECT contains the connect and disconnect times as four 8-byte store clock (STCK) values. These are: connect and disconnect time expressed in local time and connect and disconnect time in Greenwich Mean Time (GMT).

CICS statistics that contain the number of DL/I requests by type, 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'.

Related concepts
Statistics, monitoring, and performance for DBCTL
Monitoring DBCTL--transaction level data
Tuning a CICS-DBCTL system
[[ Contents Previous Page | Next Page Index ]]