Navigational DML Programming Techniques › Collecting Database Statistics

Collecting Database Statistics

You can collect database run-time statistics with the ACCEPT DATABASE-STATISTICS statement. You can issue this statement any number of times during a run unit, It returns a copy of the IDMS statistics block to a specified location in program variable storage.

Although the ACCEPT DATABASE-STATISTICS statement can be issued any number of times during a run unit, IDMS statistics are cumulative; resetting of IDMS statistics occurs only upon issuing a FINISH or ROLLBACK statement.

Uses of Database Statistics

Possible uses of database statistics include:

• Determining whether a variable-length record was stored on one page or fragments were placed in an overflow area
• Obtaining the date and time at the start and end of a run unit
• Keeping track of the number of update locks being held and issuing regular commits based on that statistic

For more information on collecting database run-time statistics and individual IDMS statistics block fields, see the language-specific CA IDMS DML Reference Guide.

'Performance Monitor users'. You can use CA IDMS Performance Monitor to collect statistics about program execution. For more information, see the CA IDMS Performance Monitor User Guide.