ISAM FILE report

The ISAM FILE report provides performance data on NK-ISAM file of ISAM pools in the Data Space.

The ISAM pools specified using a pool name, catalog ID and scope can be output in the ISAM report.

Report output

The REPORT ISAM_FILE statement is used to request the output of the ISAM FILE report.

The ISAM FILE report can only be output if the SM2 administrator has

• defined the name of a NK-ISAM file using the ADD-ISAM-FILE statement

• started ISAM pool monitoring using the START-MEASUREMENT-PROGRAM TYPE=*ISAM statement

The privileged user receives values for all measured ISAM files.
The nonprivileged user receives values only on the measured ISAM files belonging to their user ID.

 HOST0001 SM2 ISAM FILE           CYCLE:   60 S                   <date>  <time>

             FILENAME                |        FIX       SLOT|    INDEX   | SIZE 
                                     |   OP  |HIT%|WAI%|WAI%|   OP  |HIT%|
 ------------------------------------+-------+----+----+----+-------+----+-----
:2OS6:$UID.SM2.ISAMFILE              |   1.4 |72.2| 0.0| 0.0|   0.7 |97.4|   512

Monitoring information

FILENAME	Name of the NK-ISAM file. It is possibly shortened spent; there is output a '>' as last character.
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
WAI%	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
WAI%	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)