Tools to Monitor the Statistics Facility

Sterling Connect:Direct® provides the following tools for monitoring the statistics facility:

INQUIRE STATISTICS Command
S2 Statistics Records
The S2 statistics records contain information about the statistics logging function. The system writes the records about once per hour when activity exists in the DTF. Each S2 record contains statistics about the period of time since the prior S2 record. The S2 statistics records include the following information:
SS Statistics Records
The SS statistics records contain information about SELECT STATISTICS processing. One SS record is written for each SELECT STATISTICS command that executes. The SS record includes information such as the index that Sterling Connect:Direct uses to search the files and the number of requests issued to the keyed and entry-sequenced clusters. The record also includes the number of records examined and rejected.
Using the DGASSTAT Utility to Determine File Usage
Use the DGASSTAT utility to find out the rate at which the system generates statistics records. DGASSTAT also performs an analysis of the contents of the statistics file showing what percentage of the records are of each record type. This utility runs as a batch job step, and analyzes a single statistics entry-sequenced file.

Parent topic: Administering Statistics