|
|
|
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 which 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 which 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 IDMS database
subsystem.
The DATA COMMUNICATION SERVICES section contains elements
vital to tracking the interactive responsiveness of the
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
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 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 which 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.
+------------------------------------------------------------------------------------------------------------------------------+ | | | CA | | PAGE 1 | | CA MICS/IDMS IDMS REPORT RUN DATE: FRIDAY, SEPTEMBER 9, 1988 | | IDM002 | | REPORTING PERIOD AUGUST 24, 1988 1:25:28 TO AUGUST 25, 1988 2:42:00 | | | |==============================================================================================================================| | | | | | | | IDMSID : CV00 | | | | | | | | |==============================================================================================================================| | | | DATABASE SERVICES | | | |------------------------------------------------------------------------------------------------------------------------------| | | | | | RECORDS | PAGES | LOCKS | | | | | | RECORDS REQUESTED 8,842,490 CALC-NO OVERFLOW 6,396 | REQUESTED 8,579,897 | TOTAL 3,190,344 | | CURRENT OF RUN UNIT 5,062,713 CALC-OVERFLOW 168 | READ 1,277,592 | SELECT 3,577,132 | | FRAGMENTS STORED 0 VIA-NO OVERFLOW 10,122 | WRITTEN 94,528 | UPDATE 297,584 | | RECORDS RELOCATED 0 VIA-OVERFLOW 1,229 | | | | | | | |------------------------------------------------------------------------------------------------------------------------------| | | | | | DATABASE CALLS 7,188,408 | DATABASE SERVICE 420,244 | ABORTS 0 | | | | | |==============================================================================================================================| | | | DATA COMMUNICATION SERVICES | | | |------------------------------------------------------------------------------------------------------------------------------| | | | | | TIME | PROGRAMS | REQUESTS | | ACCUMULATED AVERAGE | | | | TOTAL 52:48:06.10 TOTAL 0:00:02.42 | CALLED 119,824 | GETTIME 372,239 | | SYSTEM 1:33:04.53 SYSTEM 0:00:00.07 | LOADED 214 | SETTIME 12 | | USER 0:05:29.32 USER 0:00:00.00 | | | | WAIT 51:11:00.86 WAIT 0:00:02.34 | | | | | | | |------------------------------------------------------------------------------------------------------------------------------| | | | | | | TERMINAL | STORAGE | SCRATCH | QUEUE | | | | | | | READS 4,714 | GETS 506,976 | GETS 44,543 | GETS 14,180 | | WRITES 3,872 | FREES 245,622 | PUTS 33,761 | PUTS 4,780 | | ERRORS 0 | USED-STORAGE 896963392 | DELETES 16,505 | DELETES 2,431 | | READ LENGTH 165,649 | KEPT-STORAGE 28,733,248 | | | | WRITE LENGTH 5,490,173 | USED-PROGRAM 751690664 | | | | | | | | +------------------------------------------------------------------------------------------------------------------------------+
Figure 3-2. IDMS Activity Report
| Copyright © 2012 CA. All rights reserved. | Tell Technical Publications how we can improve this information |