Time versus activity graph

This topic shows how to use any record stored on either data set.

Member	CMRPRL12
Objective	to show graphically the activity over time within a given CICS
Data	Global Performance Records (Type CC) from the CMRSTATS file
Scenario	Every 5 minutes, MainView for CICS produces a Global Performance Record containing the task count for the 5-minute interval (T6FTRNCT) along with other fields if T6F=YES is set in CMRSOPT. PRL records these values in chronological order and represents them on a bar chart, as seen in Time versus activity within one day.

The control statements shown in the following figure specify the input data and the format of the report:

Time versus activity PRL statements

SET CLASS = 'R'
SET REPORTID = 'PRL12'
SET TITLE = 'T I M E    V S    A C T I V I T Y'
SET WIDTH = '82'
SET FORM   = 'STD '
DEFINE GRAPH CHAR 52
DEFINE T6FTRNCT EDIT ZZZZZ9
DEFINE NUMSTAR EDIT 99999999999999
SET BB = '&vbar SELECT TYPE CC RECORDS FROM CMRSTATS
        WHERE CMRDATE = '09/17/1999'
   COMPUTE NUMSTAR = T6FTRNCT / 10
   COMPUTE NUMSTAR = NUMSTAR + 1
   IF NUMSTAR > 51 THEN BEGIN
      COMPUTE NUMSTAR = 52
   END;
   SET &GRAPH = BB(1:&NUMSTAR)
   USING CMRDATE -
         CMRTIME -
         T6FTRNCT -
         GRAPH
REPORT
END

Note

A variable BB is used to define a string of asterisks (*); the substring feature of the SET statement is used to pick as many asterisks (*) as needed to represent the value. The minimum activity is 15 transactions in the 5-minute period, since MainView for CICS uses this many transactions to monitor the system. T6FTRNCT was divided by 5 to extract activity for a particular day that was not busy. If the line were all asterisks, this would represent a count in excess of 250 transactions in the 5-minute interval. If your daily transaction rate is 50,000, 100,000, or more, divide by 10, 20, or even 30.

Time versus activity within one day

PRL12             T I M E    V S    A C T I V I T Y          VERS:   REL5.4.0
                                                              TIME:   11:16:27
                                                              DATE: 09/08/1999
                                                              PAGE:          1

RECORDED   RECORDED TOTAL
   DATE       TIME    TASKS                                             GRAPH
--------- -------- ------ --------------------------------------------------

09/17/1999 12:14:00     79 |*******
09/17/1999 12:19:00     94 |********
09/17/1999 12:24:00    127 |************
09/17/1999 12:29:00    147 |****************
09/17/1999 12:34:00     81 |*******
09/17/1999 12:39:00    104 |*********
09/17/1999 12:44:00     86 |********
09/17/1999 12:49:00    102 |*********
09/17/1999 12:54:00    171 |****************
09/17/1999 12:59:00    147 |**************
09/17/1999 13:04:00    113 |**********
09/17/1999 13:09:00    232 |**********************
09/17/1999 13:14:00    253 |************************
09/17/1999 13:19:00    199 |*******************
09/17/1999 13:24:00    237 |***********************
09/17/1999 13:29:00    229 |**********************
09/17/1999 13:34:00    273 |**************************
09/17/1999 13:39:00    383 |*************************************
09/17/1999 13:44:00    279 |***************************
09/17/1999 13:49:00    312 |******************************
09/17/1999 13:54:00    275 |***************************
09/17/1999 13:59:00    399 |***************************************
09/17/1999 14:04:00    360 |***********************************
09/17/1999 14:09:00    401 |***************************************
09/17/1999 14:14:00    337 |*********************************
09/17/1999 14:19:00    424 |*****************************************
09/17/1999 14:24:00    339 |*********************************
09/17/1999 14:29:00    347 |**********************************
09/17/1999 14:34:00    328 |********************************
09/17/1999 14:39:00    288 |****************************

A look at the sample output in the figure shows the highs and lows of the day’s activity. Use T6FTRMCT instead of T6FTRNCT if you are interested in only terminal activity as opposed to asynchronous tasks; add other CC fields to the USING statement as needed.

Adding a particular time of day in a WHERE clause, as follows, permits you to chart, on a single page, information about peak periods, such as 12:00 P.M. to 12:59 P.M., over several months; see the following figure:

SELECT TYPE CC RECORDS FROM CMRSTATS
SET TIME = CMRTIME(1:2)
WHERE TIME = '12'

Time versus activity over several months

PRL12             T I M E    V S    A C T I V I T Y           VERS:   REL5.4.0
                                                              TIME:   11:05:36
                                                              DATE: 09/28/1999
                                                              PAGE:          1

RECORDED    TOTAL
   DATE      TASKS                                             GRAPH
--------- ------ ---------------------------------------------------

09/03/1999    102 |*********
09/04/1999    171 |****************
09/05/1999    147 |**************
09/09/1999    113 |**********
09/07/1999    232 |**********************
09/10/1999    253 |************************
10/09/1999    199 |********************
10/09/1999    237 |************************
10/13/1999    229 |***********************
10/14/1999    273 |***************************
10/17/1999    383 |***************************
10/18/1999    279 |**************************************
10/19/1999    312 |****************************
10/20/1999    275 |*******************************
10/21/1999    399 |****************************
10/24/1999    360 |****************************************
10/25/1999    409 |************************************
10/26/1999    337 |****************************************
10/27/1999    424 |**********************************
10/28/1999    339 |******************************************
11/02/1999    328 |***********************************
11/03/1999    288 |*********************************
11/04/1999    254 |*****************************
11/05/1999    278 |********************************

Time versus activity graph

On this page