Retrieving database statistics: the STAT call

The STAT call is helpful in debugging a program because it retrieves IMS database statistics. It is also helpful in monitoring and fine tuning for performance. The STAT call retrieves OSAM database buffer pool statistics and VSAM database buffer subpool statistics.

This topic contains Product-sensitive Programming Interface information.

When you issue the STAT call, you indicate:

• An I/O area into which the statistics are to be returned.
• A statistics function, which is the name of a 9-byte area whose contents describe the type and format of the statistics you want returned. The contents of the area are defined as follows:
  • The first 4 bytes define the type of statistics desired (OSAM or VSAM).
  • The 5th byte defines the format to be returned (formatted, unformatted, or summary).
  • The remaining 4 bytes are defined as follows:
    • The normal or enhanced STAT call contains 4 bytes of blanks.
    • The extended STAT call contains the 4-byte parameter ' E1 ' (a 1-byte blank, followed by a 2-byte character string, and then another 1-byte blank).