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.
idmscu
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 section
.'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 Using section
.