DEDB analysis and report

The complete analysis reports are provided to effectively manage the space utilization, performance characteristics, and physical attributes of IMS DEDBs. It provides integrity verification reports, and summary and detailed analysis reports for database administrators and technical support personnel in database management, maintenance, and performance tuning.

The statistical information includes:

  • Free space analysis, including statistics on the number and size of the free space elements and inter-database section references.
  • Database record and segment occurrence profiles.
  • Database record and segment placement analysis.
  • Complete overflow usage analysis of both dependent overflow (DOVF) and independent overflow (IOVF).
  • Physical I/O statistics for each segment type and for the typical database record.
  • Root distribution and synonym chain analysis.
  • Optional automated threshold reporting, which generates warning messages when conditions within the database do not meet user-specified criteria. This feature can be used to show when reorganization or expansion is required, or if database performance falls below acceptable standards.
  • Optional generation of:
    • A report that describes the largest database records.
    • A report that identifies the units of work (UOWs) that exceed a user-specified reorganization criteria.
    • The control statements that are required to run the IMS High-Speed DEDB Direct Reorganization utility (DBFUMDR0).

Reorganizing specific UOWs can significantly reduce the time and resources that are required for database maintenance.