Using the Application Monitor › DB Statistics (PF6)

DB Statistics (PF6)

 PM-Rnn.n SYSTEM71         CA, Inc.                  V71      08.348 03:44:46.54
 CMD-->                                                             Window : 04

   04 DB Statistics       IDD      611                      3:40:25.3629

 * I/O Information *                   * DB Navigation *
   Pages Written              3          Records Requested              77
   Pages Read                14          Records Current                14
   Pages Requested           32          Records Updated
 * Overflow Information *                Records Fnd Cache
   Calc No Ovflo              1          Records Fnd Prefetch
   Calc Ovflo                          * Locking Information *
   Via No Ovflo               1          Total Locks Acquired           73
   Via Overflow                          Select Locks Held
   Frags Stored                          Update Locks Held
   Records Relo                          Total Locks Held

                                         DB Service Reqs                50

Screen Description

The DB Statistics screen displays detailed database statistics for the current task.

Using this Screen

• Press [PF2] to go to the ADS Statistics screen.
• Press [PF9] to go to the DC Statistics screen.
• Press [PF4] to display DB statistics for the next task, as shown on the Task List screen.
• Press [PF5] to display DB statistics for the previous task, as shown on the Task List screen.

What To Look For

• Look for a high number in any of the following fields:
  • Calc Ovfl
  • Via Overflow
  • Frags Stored

  These fields indicate that target pages for records stored by the task were full, forcing CA IDMS to store the records on other pages. If necessary, use the IDMSDBAN utility to analyze space availability for database pages. If a large number of pages in the database are full, consider increasing the database page size or the number of pages in the database.

• Look for a high number in the Records Requested field compared to the number in the Records Current field.
• Look at the ratio of pages requested to pages read. The ratio indicates the effectiveness of the buffer size and database design. Low ratios may indicate that the buffer is too small or that the database needs to be tuned.