

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.
Copyright © 2014 CA.
All rights reserved.
 
|
|