Previous Topic: Monitoring GuidelinesNext Topic: Database Statistics


Monitoring Facilities

Online and Batch Components

CA IDMS/DB offers the following online and batch tools for you to use to monitor the performance of your databases:

Facility

Uses

Performance Monitor

To monitor:

  • Real-time database and system statistics
  • System-wide, wait-time statistics for a unit of time

Statistics about resource usage by individual programs

DCMT commands

To display definitions and run-time statistics for entities associated with a DC/UCF system

IDMSDBAN utility program

To check for broken chains and to display statistics and data for sets, records, and areas

OPER WATCH commands

To display dynamic run-time statistics associated with DC/UCF systems

PRINT INDEX utility statement

To monitor the structure of user-owned and system-owned indexes

PRINT SPACE utility statement

To monitor space utilization in segments or areas

PRINT JOURNAL utility statement

To display checkpoint information about transactions recorded on an archive or tape journal file

PRINT utility statement

To display the contents of requested database pages

JREPORTs

To monitor journal and database usage statistics

SREPORTs

To monitor system and database usage statistics

Online print log (PLOG)

To display system messages, system trace information, and snap dumps from the DDLDCLOG area

UPDATE STATISTICS utility statement

To refresh statistical information about SQL defined databases, and non-SQL defined databases that are accessed by SQL commands.

More Information