Using the Application Monitor › Dbkey Statistics (PF9)

Dbkey Statistics (PF9)

 PM-Rnn.n SYSTEM71         CA, Inc.                  V71      08.348 17:14:37.37
 CMD-->                                                             Window : 02

   02 DBkey Statistics    ITMIGR   56064                   12:48:41.5136      >
                         Page  Lock            Wait  Type of     Name of
            DBkey       Group  Type            Time  Holder      Holder
      1054117:  0           0  CURRENCY      .1668S  TASK        ADS2

 PM-Rnn.n SYSTEM71         CA, Inc.                  V71      08.348 17:14:37.37
 CMD-->                                                             Window : 02

   02 DBkey Statistics    ITMIGR   56064                   12:48:41.5136   <
                 Type of     Name of
          DBkey  Holder      Holder      Area Name           File Name
    1054117:  0  TASK        ADS2        DDLDCRUN            SYS72-DDLDCRUN

Screen Description

The DBkey Statistics screen displays information on database keys on which the task occurrence waited.

Using this Screen

• Press [PF2] to go to the General Statistics screen.
• Press [PF9] to go to the Wait Statistics screen.
• Press [PF4] to display database key statistics for the next task, as shown on the Task List screen.
• Press [PF5] to display database key statistics for the previous task as shown on the Task List screen.

What To Look For

• Look for db-key locks appearing in the Lock Type field. If they appear consistently, check the Name of Holder field to determine the task holding this type of lock.
• Look for db-keys that are consistently being waited on. This can indicate that commonly accessed record or row occurrences (such as OOAKs) are limiting the throughput of the system.