Previous Topic: 3.1.2.3 IDMS Response Time Report (IDM003)

Next Topic: 3.1.2.5 IDMS Online Transactions Report (IDM005)

3.1.2.4 IDMS Calendar Report (IDM004)


INTENDED USAGE:

   The IDMS Calendar Report provides, on a daily basis, an
   updated view of key elements which are factors in judging
   the performance and effectiveness of the IDMS systems
   currently in use.  From this report you can track the
   current month's utilization of IDMS.

FORMAT:

   The report is produced by the SAS Calendar procedure.  A
   report will be produced for each IDMSID processed
   month-to-date within this unit.  Since the current daily
   cycle is updated, the calendar will reflect up to one full
   month's activity.  This report makes key indicators
   available to assist you in simple daily tracking of IDMS
   performance.

   A sample of the IDMS Calendar Report is presented in
   Figure 3-4.

DATABASE FILE USED:

   IDMSCL01 at the DAYS timespan.  This is the special data
   set which is updated to contain month-to-date information.


DATA ELEMENTS USED:

   SCLTTRAN - Total transactions for a given day
   SCLABNDS - Total transactions ABENDed for a given day
   SCLDBCLS - Total database calls issued for a given day
   SCLCPUTM - Calculated total of system and user CPU time,
              in seconds
   SCLAVTTM - Overall average response time for a given day
   SCLAVPIO - Average physical I/O issued per task for a
              given day
   SCLAVDBC - Average database calls issued per task for a
              given day
   SCLAVTIO - Average terminal I/O issued per task for a
              given day

REPORT LABELS USED:

   SCLTTRAN - Shown as TRANS in each day's block
   SCLABNDS - Shown as ABENDS in each day's block
   SCLDBCLS - Shown as DB CLS in each day's block
   SCLCPUTM - Shown as CPU SEC in each day's block
   SCLAVTTM - Shown as RSP SEC in each day's block
   SCLAVPIO - Shown as AVG PIO in each day's block
   SCLAVDBC - Shown as AVG DBC in each day's block
   SCLAVTIO - Shown as AVG TIO in each day's block

CALCULATIONS USED:

   Total CPU time used expressed in seconds, CPU SEC, is
   maintained in the element SCLCPUTM and is the sum of
   system and user CPU times:

       SCLCPUTM = SCLSYSTM + SCLUSRTM

   Average physical I/O requests per task, AVG PIO, is
   maintained in the element SCLAVPIO as the sum of pages
   read plus pages written divided by the total number of
   transactions executed:

       SCLAVPIO = (SCLPREAD + SCLPWRIT) / SCLTTRAN

   Average database calls per task, AVG DBC, is maintained
   in the element SCLAVDBC as the number of database calls
   issued per day divided by the total number of transactions
   executed:

       SCLAVDBC = SCLDBCLS / SCLTTRAN

   Average terminal I/O requests per task, AVG TIO, is
   maintained in the element SCLAVTIO as the sum of terminal
   read plus terminal write requests divided by the total
   number of transactions executed:

       SCLAVTIO = (SCLTREAD + SCLTWRIT) / SCLTTRAN

USAGE CONSIDERATIONS:

   This report is produced as part of the execution of the
   normal daily update job standard report step DAY400.  No
   special options are necessary to produce this report.
   IDMS Standard Report Options have no impact on the
   generation or selection criteria used to produce this
   report.

   The calendar report provides key indicators for daily
   performance evaluation and short-term trending analysis.
   By viewing the calendar produced for each Central Version
   system defined, you can judge the major resource
   utilization factors that are essential to the performance
   of the IDMS system.

   These are the more critical factors which need to be
   reviewed to obtain a clear picture of what might be
   happening within each Central Version; they are not all of
   the factors.  The elements shown typically change during
   growth times or heavy-degradation periods.  By keeping a
   month-to-date running file, you can perform short-term
   trending of the IDMS systems showing peaks, valleys, and
   possible growth times.  Although the calendar is only
   showing the current month's data, the file contains data
   from the past three months.


I D M S C O M P O N E N T DAILY IDMS SUMMARY System Identifier=MVSA IDMS System Identification=CV00 AUGUST 1988 ------------------------------------------------------------------------------------------------------------------------------ | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | |-----------------+-----------------+-----------------+-----------------+-----------------+-----------------+----------------| | | | | | 1 | 2 | 3 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |-----------------+-----------------+-----------------+-----------------+-----------------+-----------------+----------------| | 4 | 5 | 6 | 7 | 8 | 9 | 10 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |-----------------+-----------------+-----------------+-----------------+-----------------+-----------------+----------------| | 11 | 12 | 13 | 14 | 15 | 16 | 17 | | | 1,970 TRANS | 3,010 TRANS | 2,681 TRANS | 1,820 TRANS | 3,564 TRANS | | | | 6 ABENDS | 6 ABENDS | 12 ABENDS | 8 ABENDS | 10 ABENDS | | | | 444,223 DB CLS | 520,935 DB CLS |1,002,406 DB CLS | 350,152 DB CLS | 948,435 DB CLS | | | | 642.9 CPU SEC | 743.3 CPU SEC | 1,250.6 CPU SEC | 610.9 CPU SEC | 1,098.3 CPU SEC | | | | 18.9 RSP SEC | 7.5 RSP SEC | 3.8 RSP SEC | 2.3 RSP SEC | 5.3 RSP SEC | | |-----------------+-----------------+-----------------+-----------------+-----------------+-----------------+----------------| | 18 | 19 | 20 | 21 | 22 | 23 | 24 | | | 4,280 TRANS | 1,114 TRANS | 326 TRANS | 3,574 TRANS | 164 TRANS | | | | 29 ABENDS | 1 ABENDS | 0 ABENDS | 20 ABENDS | 0 ABENDS | | | |1,745,203 DB CLS | 113,396 DB CLS | 38,192 DB CLS | 693,933 DB CLS | 1,607 DB CLS | | | | 2,226.7 CPU SEC | 189.4 CPU SEC | 75.7 CPU SEC | 1,116.0 CPU SEC | 2.5 CPU SEC | | | | 13.8 RSP SEC | 1.3 RSP SEC | 2.4 RSP SEC | 6.4 RSP SEC | 0.6 RSP SEC | | |-----------------+-----------------+-----------------+-----------------+-----------------+-----------------+----------------| | 25 | 26 | 27 | 28 | 29 | 30 | 31 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | ------------------------------------------------------------------------------------------------------------------------------ --------------------------------- | | SUM | | TRANS | 22503 | | ABENDS | 92 | | DB CLS | 5858482 | | CPU SEC | 7956.72319481 | ---------------------------------

Figure 3-4. IDMS Calendar Report (Page 1 of 2)

I D M S C O M P O N E N T DAILY IDMS SUMMARY System Identifier=MVSA IDMS System Identification=CV00 AUGUST 1988 ------------------------------------------------------------------------------------------------------------------------------ | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | |-----------------+-----------------+-----------------+-----------------+-----------------+-----------------+----------------| | | | | | 1 | 2 | 3 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |-----------------+-----------------+-----------------+-----------------+-----------------+-----------------+----------------| | 4 | 5 | 6 | 7 | 8 | 9 | 10 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |-----------------+-----------------+-----------------+-----------------+-----------------+-----------------+----------------| | 11 | 12 | 13 | 14 | 15 | 16 | 17 | | | 633,032 TOT IO | 543,945 TOT IO | 763,341 TOT IO | 522,648 TOT IO | 511,846 TOT IO | | | | 14 AVG PIO | 95 AVG PIO | 67 AVG PIO | 34 AVG PIO | 55 AVG PIO | | | | 563 AVG LIO | 524 AVG LIO | 347 AVG LIO | 562 AVG LIO | 563 AVG LIO | | | | 74 AVG DBC | 81 AVG DBC | 98 AVG DBC | 76 AVG DBC | 56 AVG DBC | | | | 0 AVG TIO | 0 AVG TIO | 0 AVG TIO | 0 AVG TIO | 0 AVG TIO | | |-----------------+-----------------+-----------------+-----------------+-----------------+-----------------+----------------| | 18 | 19 | 20 | 21 | 22 | 23 | 24 | | | 533,032 TOT IO | 743,345 TOT IO | 863,241 TOT IO | 542,648 TOT IO | 611,876 TOT IO | | | | 34 AVG PIO | 45 AVG PIO | 47 AVG PIO | 44 AVG PIO | 56 AVG PIO | | | | 553 AVG LIO | 564 AVG LIO | 447 AVG LIO | 542 AVG LIO | 573 AVG LIO | | | | 84 AVG DBC | 91 AVG DBC | 108 AVG DBC | 66 AVG DBC | 66 AVG DBC | | | | 0 AVG TIO | 0 AVG TIO | 0 AVG TIO | 0 AVG TIO | 0 AVG TIO | | |-----------------+-----------------+-----------------+-----------------+-----------------+-----------------+----------------| | 25 | 26 | 27 | 28 | 29 | 30 | 31 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | ------------------------------------------------------------------------------------------------------------------------------ --------------------------------- | | SUM | | TOT IO | 63852453 | ---------------------------------

Figure 3-4. IDMS Calendar Report (Page 2 of 2)