INTENDED USAGE:
The IDMS Activity Report displays parameters important for
high-level performance tuning in the areas of database
services and data communications services.
FORMAT:
The report has three sections: the report heading
section, the DATABASE SERVICES section, and the DATA
COMMUNICATION SERVICES section.
The report heading indicates the date the report was
produced and the time period that it reports. It also
lists the values of the summarization variables previously
set by the system administrator as BY variables in the
IDMRPTS member of prefix.MICS.PARMS that control the
selection, sequencing, and summarization of the reports.
The DATABASE SERVICES section contains key elements
related to database activity for the specified period and
BY element selection criteria. The section is grouped to
report on elements related to records, calls, pages,
aborts, and locks issued against the CA IDMS database
subsystem.
The DATA COMMUNICATION SERVICES section contains elements
vital to tracking the interactive responsiveness of the
CA IDMS Universal Communication Facility. This section
groups related elements for easier viewing. The
subsections indicate the various usage areas you should
monitor to help determine queue, pool, and storage
requirements.
A sample of the IDMS Activity Report is presented in
Figure 3-2.
DATABASE FILE USED:
IDMSUA - IDMS User Activity File
DATA ELEMENTS USED:
DATABASE SERVICES - RECORDS subsection:
SUARECR SUARECU SUAFRAG SUARELOC SUACREC
SUACRECO SUAVREC SUAVRECO
DATABASE SERVICES - PAGES subsection:
SUAPREQ SUAPREAD SUAPWRIT
DATABASE SERVICES - LOCKS subsection:
SUATLKS SUASLKS SUAULKS
DATABASE SERVICES - CALLS subsection:
SUADBCLS
DATABASE SERVICES - SERVICE subsection:
SUADBSRV
DATABASE SERVICES - ABORTS subsection:
SUAABNDS
DATA COMMUNICATION SERVICES - TIME subsection:
SUATRSTM SUASYSTM SUAUSRTM SUAWTTM SUASPNTM
DATA COMMUNICATION SERVICES - PROGRAMS subsection:
SUAPCALL SUAPLOAD
DATA COMMUNICATION SERVICES - REQUESTS subsection:
SUAGETTM SUASETTM
DATA COMMUNICATION SERVICES - TERMINAL subsection:
SUATREAD SUATWRIT SUATERRS SUATRLEN SUATWLEN
DATA COMMUNICATION SERVICES - STORAGE subsection:
SUASGET SUASFREE SUAUSDS SUAKPTS SUAUSDP
DATA COMMUNICATION SERVICES - SCRATCH subsection:
SUAXGET SUAXPUT SUAXDEL
DATA COMMUNICATION SERVICES - QUEUE subsection:
SUAQGET SUAQPUT SUAQDEL
REPORT LABELS USED:
Not applicable. The labels are self-explanatory as viewed
within the specific section or subsection.
CALCULATIONS USED:
All elements have been summed based upon the BY variables
specified in the general section at the top of the page.
The AVERAGE time elements are computed based upon the data
selection performed.
USAGE CONSIDERATIONS:
This report provides most of the elements necessary to
accomplish high-level performance tuning of the CA IDMS
reporting group as specified in the BY variables. This
report will be very useful in the initial stages of a
tuning effort or as visual input for trending studies
since you may specify the grouping that interests you.
This report narrows the scope of any detail analysis down
to a small subset of the total system load, thereby
eliminating many hours of effort to view detail-level
data.
+------------------------------------------------------------------------------------------------------------------------------+ | | | COMPLEX REPORT | | PAGE 1 | | MICS/IDMS IDMS REPORT RUN DATE: Friday, December 14, 2012 | | IDM002 | | REPORTING PERIOD October 9, 2012 14:08:13 TO October 9, 2012 16:59:57 | | | |==============================================================================================================================| | | | | | | | SYSID : SYSA | | | | | | | | | | | | | | | | | | | | | | | |==============================================================================================================================| | | | | | DATABASE SERVICES | | | |------------------------------------------------------------------------------------------------------------------------------| | | | | | RECORDS | PAGES | LOCKS | | | | | | RECORDS REQUESTED 43,354,252 CALC-NO OVERFLOW 16,754 | REQUESTED 28,734,777 | TOTAL 83,307,498 | | CURRENT OF RUN UNIT 19,263,728 CALC-OVERFLOW 2,741 | READ 1,170,031 | SELECT 0 | | FRAGMENTS STORED 140 VIA-NO OVERFLOW 111,680 | WRITTEN 164,782 | UPDATE 0 | | RECORDS RELOCATED 0 VIA-OVERFLOW 31,282 | | | | | | | |------------------------------------------------------------------------------------------------------------------------------| | | | | | DATA BASE CALLS 64,513,877 | DATA BASE SERVICE 64,513,877 | ABORTS 26 | | | | | |==============================================================================================================================| | | | | | DATA COMMUNICATION SERVICES | | | |------------------------------------------------------------------------------------------------------------------------------| | | | | | TIME | PROGRAMS | REQUESTS | | ACCUMULATED AVERAGE | | | | TOTAL 17:48:33.90 TOTAL 0:00:00.16 | CALLED 6,270,832 | GETTIME 4,595,638 | | SYSTEM 0:15:58.87 SYSTEM 0:00:00.00 | LOADED 254 | SETTIME 2 | | USER 0:06:03.36 USER 0:00:00.00 | | | | WAIT 17:27:50.63 WAIT 0:00:00.15 | | | | ZIIP 0:26:01.47 ZIIP 0:00:00.00 | | | | | | | |------------------------------------------------------------------------------------------------------------------------------| | | | | | | TERMINAL | STORAGE | SCRATCH | QUEUE | | | | | | | READS 7,388 | GETS 16,156,233 | GETS 293,499 | GETS 1,895 | | WRITES 24,408 | FREES 15,499,550 | PUTS 201,119 | PUTS 1,204 | | ERRORS 274 | USED-STORAGE 2.53947E10 | DELETES 200,593 | DELETES 684 | | READ LENGTH 12,937,555 | KEPT-STORAGE 2074804992 | | | | WRITE LENGTH 39,261,396 | USED-PROGRAM 2.09503E10 | | | | | | | | +------------------------------------------------------------------------------------------------------------------------------+
Figure 3-2. IDMS Activity Report
|
Copyright © 2014 CA.
All rights reserved.
|
|