The ISAM reports provide monitored data for ISAM pools which were specified using the pool name, catalog ID and scope. Monitoring covers all files contained in the pool.
File-specific analyses within global ISAM pools in the data space can be output in the ISAM FILE report.
Report output
The REPORT ISAM statement is used to request the output of the ISAM report.
The ISAM report consists of the following sections:
USER ISAM report for the ISAM user-specific monitoring program
PRIVILEGED ISAM report for the ISAM monitoring program (for privileged users only).
The USER ISAM report can only be output when the SM2 administrator
has used the statement MODIFY-USER-ADMISSION ISAM=*ALLOW to permit the ISAM user-specific monitoring program and
included ISAM pools in the monitoring process using the START-/CHANGE-ISAM-STATISTICS statement
The PRIVILEGED ISAM report can only be output if the SM2 administrator has
defined ISAM pools using the ADD-ISAM-POOL statement
started ISAM pool monitoring using the START-MEASUREMENT-PROGRAM TYPE=*ISAM statement
Outputting monitored data in the ISAM reports
In the USER ISAM report, the nonprivileged user receives the values of the ISAM pool of the ISAM user-specific monitoring program that he or she has included.
In the PRIVILEGED ISAM report, the privileged user is shown the values for all the ISAM pools included in the monitoring process by an SM2 administrator for the ISAM monitoring program using ADD-ISAM-POOL. These values are also written to the SM2 output file.
The layout of the ISAM reports for nonprivileged users and for privileged users is identical, except for the header (report entitled SM2 USER ISAM REPORT for nonprivileged users, and SM2 PRIVILEGED ISAM REPORT for privileged users).
HOST0001 SM2 PRIVILEGED ISAM CYCLE: 60 S <date> <time>
POOLNAME|SC|CAT-ID| TSN | FIX SLOT | INDEX | SIZE
| | | | OP | HIT% | WAIT%| WAIT%| OP | HIT% |
--------+--+------+--------+--------+------+------+------+-------+------+------
SRPMPOOL|TA| 2OSH |RP01 | 34.9 |100.0 | 0.0 | 0.0 | 23.3 |100.0 | 138
$SYS01 |HS| 2OSH | | | | | | | |
--------+--+------+--------+--------+------+------+------+-------+------+------
Monitoring information
POOLNAME | Name of the monitored ISAM pool |
SC | Identifies the relevant ISAM pool as global (HOST-SYSTEM, HS) or task-local (TASK, TA) |
CAT-ID | Catalog ID of the pubset specified for the monitored ISAM pool |
USER-ID/TSN | Task sequence number (TSN) of the task under which a task-local ISAM pool was created. This column remains empty for global ISAM pools. |
FIX | |
OP | Number of FIX operations per second (number of FIX hits + number of FIX waits + number of FIX IOs). This also contains the number of accesses to the index. |
HIT% | Percentage of FIX operations where the desired buffer page is already in the ISAM pool (i.e. no read operation from disk is required) relative to the total number of all FIX operations |
WAIT% | Percentage of FIX operations requiring a waiting period until one or more buffer pages are released relative to the total number of all FIX operations |
SLOT | |
WAIT% | Percentage of RESERVE-SLOT operations leading to a wait state for the requested task due to a slot bottleneck relative to the total number of all RESERVE-SLOT operations |
INDEX | |
OP | Number of accesses to the index per second |
HIT% | Percentage of all accesses to the index accounted for by accesses to the index where the index searched for is already in the ISAM pool |
SIZE | Size of the ISAM pool in 2 KB pages (excluding some administration data) |
If an ISAM pool is never addressed during a monitoring cycle, the last seven columns contain blanks.