DBkey/Area Detail (PF3)

Using the Interval Monitor › DBkey/Area Detail (PF3)

DBkey/Area Detail (PF3)

PM-Rnn.n SYSTEM71 CA, Inc. V71 08.348 10:59:08.64 CMD--> Window : 02 02 10:30 DBDT DBkey/Area Detail > Area Name Area_Access Physical Physical Buffer Prefetch Waits Writes Reads Hits Hits _ APPLDICT.DDLDML 0 0 0 0 0 _ APPLDICT.DDLDCLOD 0 0 4 0 0 _ CATSYS.DDLCAT 0 0 0 0 0 _ CATSYS.DDLCATX 0 0 0 0 0 _ CATSYS.DDLCATLOD 0 0 0 0 0 _ DBCR.BRNCHTEL 0 0 0 0 0 _ DBCR.BRNCHTEL 0 0 0 0 0 _ DBCR.BRNCHTEL 0 0 0 0 0 _ DBCR.BRNCHTEL 0 0 0 0 0 _ DBCR.ACCTHIST 0 0 0 0 0 _ DBCR.ACCTHIST 0 0 0 0 0 _ DBCR.ACCTHIST 0 0 0 0 0 _ DBCR.ACCTHIST 0 0 0 0 0 _ DBCR.ACCTHIST 0 0 0 0 0 _ EMPDEMO.EMP-DEMO-REGION 0 0 0 0 0 _ EMPDEMO.INS-DEMO-REGION 0 0 0 0 0 _ EMPDEMO.ORG-DEMO-REGION 0 0 0 0 0 _ PROJSEG.PROJAREA 0 0 0 0 0

PM-Rnn.n SYSTEM71 CA, Inc. V71 08.348 10:59:08.64 CMD--> Window : 02 02 10:30 DBDT DBkey/Area Detail < > Area Name Prefetch D-Space D-Space D-Space Sh-Cache Hits Reads Hits Writes Reads _ APPLDICT.DDLDML 0 0 0 0 0 _ APPLDICT.DDLDCLOD 0 0 0 0 0 _ CATSYS.DDLCAT 0 0 0 0 0 _ CATSYS.DDLCATX 0 0 0 0 0 _ CATSYS.DDLCATLOD 0 0 0 0 0 _ DBCR.BRNCHTEL 0 0 0 0 0 _ DBCR.BRNCHTEL 0 0 0 0 0 _ DBCR.BRNCHTEL 0 0 0 0 0 _ DBCR.BRNCHTEL 0 0 0 0 0 _ DBCR.ACCTHIST 0 0 0 0 0 _ DBCR.ACCTHIST 0 0 0 0 0 _ DBCR.ACCTHIST 0 0 0 0 0 _ DBCR.ACCTHIST 0 0 0 0 0 _ DBCR.ACCTHIST 0 0 0 0 0 _ EMPDEMO.EMP-DEMO-REGION 0 0 0 0 0 _ EMPDEMO.INS-DEMO-REGION 0 0 0 0 0 _ EMPDEMO.ORG-DEMO-REGION 0 0 0 0 0 _ PROJSEG.PROJAREA 0 0 0 0 0

PM-Rnn.n SYSTEM71 CA, Inc. V71 08.348 10:59:08.64 CMD--> Window : 02 02 10:30 DBDT DBkey/Area Detail < > Area Name Sh-Cache Sh-Cache Sh-Cache Sh-Cache DBIO Reads Hits Writes Failed Waits _ APPLDICT.DDLDML 0 0 0 0 0 _ APPLDICT.DDLDCLOD 0 0 0 0 4 _ CATSYS.DDLCAT 0 0 0 0 0 _ CATSYS.DDLCATX 0 0 0 0 0 _ CATSYS.DDLCATLOD 0 0 0 0 0 _ DBCR.BRNCHTEL 0 0 0 0 0 _ DBCR.BRNCHTEL 0 0 0 0 0 _ DBCR.BRNCHTEL 0 0 0 0 0 _ DBCR.BRNCHTEL 0 0 0 0 0 _ DBCR.ACCTHIST 0 0 0 0 0 _ DBCR.ACCTHIST 0 0 0 0 0 _ DBCR.ACCTHIST 0 0 0 0 0 _ DBCR.ACCTHIST 0 0 0 0 0 _ DBCR.ACCTHIST 0 0 0 0 0 _ EMPDEMO.EMP-DEMO-REGION 0 0 0 0 0 _ EMPDEMO.INS-DEMO-REGION 0 0 0 0 0 _ EMPDEMO.ORG-DEMO-REGION 0 0 0 0 0 _ PROJSEG.PROJAREA 0 0 0 0 0

PM-Rnn.n SYSTEM71 CA, Inc. V71 08.348 10:59:08.64 CMD--> Window : 02 02 10:30 DBDT DBkey/Area Detail < > Area Name DBIO DBIO Prior_DBIO Prior_DBIO DB_Buf Waits Time Waits Time Waits _ APPLDICT.DDLDML 0 .0000S 0 .0000S 0 _ APPLDICT.DDLDCLOD 4 .0794S 0 .0000S 0 _ CATSYS.DDLCAT 0 .0000S 0 .0000S 0 _ CATSYS.DDLCATX 0 .0000S 0 .0000S 0 _ CATSYS.DDLCATLOD 0 .0000S 0 .0000S 0 _ DBCR.BRNCHTEL 0 .0000S 0 .0000S 0 _ DBCR.BRNCHTEL 0 .0000S 0 .0000S 0 _ DBCR.BRNCHTEL 0 .0000S 0 .0000S 0 _ DBCR.BRNCHTEL 0 .0000S 0 .0000S 0 _ DBCR.ACCTHIST 0 .0000S 0 .0000S 0 _ DBCR.ACCTHIST 0 .0000S 0 .0000S 0 _ DBCR.ACCTHIST 0 .0000S 0 .0000S 0 _ DBCR.ACCTHIST 0 .0000S 0 .0000S 0 _ DBCR.ACCTHIST 0 .0000S 0 .0000S 0 _ EMPDEMO.EMP-DEMO-REGION 0 .0000S 0 .0000S 0 _ EMPDEMO.INS-DEMO-REGION 0 .0000S 0 .0000S 0 _ EMPDEMO.ORG-DEMO-REGION 0 .0000S 0 .0000S 0 _ PROJSEG.PROJAREA 0 .0000S 0 .0000S 0

PM-Rnn.n SYSTEM71 CA, Inc. V71 08.348 10:59:08.64 CMD--> Window : 02 02 10:30 DBDT DBkey/Area Detail < > Area Name DB_Buf DB_Buf SHR_Buf SHR_Buf EXC_Buf EXC_Buf Waits Time Waits Time Waits Time _ APPLDICT.DDLDML 0 .0000S 0 .0000S 0 .0000S _ APPLDICT.DDLDCLOD 0 .0000S 0 .0000S 0 .0000S _ CATSYS.DDLCAT 0 .0000S 0 .0000S 0 .0000S _ CATSYS.DDLCATX 0 .0000S 0 .0000S 0 .0000S _ CATSYS.DDLCATLOD 0 .0000S 0 .0000S 0 .0000S _ DBCR.BRNCHTEL 0 .0000S 0 .0000S 0 .0000S _ DBCR.BRNCHTEL 0 .0000S 0 .0000S 0 .0000S _ DBCR.BRNCHTEL 0 .0000S 0 .0000S 0 .0000S _ DBCR.BRNCHTEL 0 .0000S 0 .0000S 0 .0000S _ DBCR.ACCTHIST 0 .0000S 0 .0000S 0 .0000S _ DBCR.ACCTHIST 0 .0000S 0 .0000S 0 .0000S _ DBCR.ACCTHIST 0 .0000S 0 .0000S 0 .0000S _ DBCR.ACCTHIST 0 .0000S 0 .0000S 0 .0000S _ DBCR.ACCTHIST 0 .0000S 0 .0000S 0 .0000S _ EMPDEMO.EMP-DEMO-REGION 0 .0000S 0 .0000S 0 .0000S _ EMPDEMO.INS-DEMO-REGION 0 .0000S 0 .0000S 0 .0000S _ EMPDEMO.ORG-DEMO-REGION 0 .0000S 0 .0000S 0 .0000S _ PROJSEG.PROJAREA 0 .0000S 0 .0000S 0 .0000S

PM-Rnn.n SYSTEM71 CA, Inc. V71 08.348 10:59:08.64 CMD--> Window : 02 02 10:30 DBDT DBkey/Area Detail < Area Name EXC_Buf DBkey DBkey Sh-Cache Sh-Cache Time Waits Time Waits Time _ APPLDICT.DDLDML .0000S 0 .0000S 0 .0000S _ APPLDICT.DDLDCLOD .0000S 0 .0000S 0 .0000S _ CATSYS.DDLCAT .0000S 0 .0000S 0 .0000S _ CATSYS.DDLCATX .0000S 0 .0000S 0 .0000S _ CATSYS.DDLCATLOD .0000S 0 .0000S 0 .0000S _ DBCR.BRNCHTEL .0000S 0 .0000S 0 .0000S _ DBCR.BRNCHTEL .0000S 0 .0000S 0 .0000S _ DBCR.BRNCHTEL .0000S 0 .0000S 0 .0000S _ DBCR.BRNCHTEL .0000S 0 .0000S 0 .0000S _ DBCR.ACCTHIST .0000S 0 .0000S 0 .0000S _ DBCR.ACCTHIST .0000S 0 .0000S 0 .0000S _ DBCR.ACCTHIST .0000S 0 .0000S 0 .0000S _ DBCR.ACCTHIST .0000S 0 .0000S 0 .0000S _ DBCR.ACCTHIST .0000S 0 .0000S 0 .0000S _ EMPDEMO.EMP-DEMO-REGION .0000S 0 .0000S 0 .0000S _ EMPDEMO.INS-DEMO-REGION .0000S 0 .0000S 0 .0000S _ EMPDEMO.ORG-DEMO-REGION .0000S 0 .0000S 0 .0000S _ PROJSEG.PROJAREA .0000S 0 .0000S 0 .0000S

Screen Description

The DBkey/Area Detail screen displays detailed information for db-key and area waits for the current interval.

The screen includes one line for each area, which shows the total count and time of all access requests that resulted in a db-key wait and shows statistics by retrieval mode for area waits.

Using This Screen

To request the Area Detail screen for a specific area, type any nonblank character to the left of the desired area and press [Enter].
To request the DBkey/Area History screen, press [PF9].

What To Look For

Look for waits in the Area_Access Waits field. This field indicates the number of times a task had to wait to access the area because of its READY mode (for example, exclusive update).
Look at the Buffer Hits field. The values in the field should be high, indicating effective use of the area's buffer.
Look for waits during an interval. Use the Realtime Monitor Active Tasks screen to determine the specific db-keys and db-key holders. You can also use the Application Monitor to see detailed wait information broken down by task.