IO Detail (PF5)

Using the Interval Monitor › IO Detail (PF5)

IO Detail (PF5)

PM-Rnn.n SYSTEM71 CA, Inc. V71 08.348 11:02:52.67 CMD--> Window : 02 02 10:30 IODT IO Detail > Area Name File Name Read Read Write Write Waits Time Waits Time _ APPLDICT.DDLDML APPLDICT.DICTDB 0 .0000S 0 .0000S _ APPLDICT.DDLDCLOD APPLDICT.DLODDB 4 .0794S 0 .0000S _ CATSYS.DDLCAT CATSYS.DCCAT 0 .0000S 0 .0000S _ CATSYS.DDLCATX CATSYS.DCCATX 0 .0000S 0 .0000S _ CATSYS.DDLCATLOD CATSYS.DCCATL 0 .0000S 0 .0000S _ DBCR.BRNCHTEL DBCR.BRANCHA 0 .0000S 0 .0000S _ DBCR.BRNCHTEL DBCR.BRANCHB 0 .0000S 0 .0000S _ DBCR.BRNCHTEL DBCR.BRANCHC 0 .0000S 0 .0000S _ DBCR.BRNCHTEL DBCR.BRANCHD 0 .0000S 0 .0000S _ DBCR.ACCTHIST DBCR.ACCOUNTA 0 .0000S 0 .0000S _ DBCR.ACCTHIST DBCR.ACCOUNTB 0 .0000S 0 .0000S _ DBCR.ACCTHIST DBCR.ACCOUNTC 0 .0000S 0 .0000S _ DBCR.ACCTHIST DBCR.ACCOUNTD 0 .0000S 0 .0000S _ DBCR.ACCTHIST DBCR.ACCOUNTE 0 .0000S 0 .0000S _ EMPDEMO.EMP-DEMO-REGION EMPDEMO.EMPDEMO 0 .0000S 0 .0000S _ EMPDEMO.INS-DEMO-REGION EMPDEMO.INSDEMO 0 .0000S 0 .0000S _ EMPDEMO.ORG-DEMO-REGION EMPDEMO.ORGDEMO 0 .0000S 0 .0000S _ PROJSEG.PROJAREA PROJSEG.PROJDEMO 0 .0000S 0 .0000S

PM-Rnn.n SYSTEM71 CA, Inc. V71 08.348 11:02:52.67 CMD--> Window : 02 02 10:30 IODT IO Detail < > Area Name Write Buffer Name Buffer Buffer Time Requests Waits _ APPLDICT.DDLDML .0000S DEFAULT_BUFFER 0 0 _ APPLDICT.DDLDCLOD .0000S DEFAULT_BUFFER 0 0 _ CATSYS.DDLCAT .0000S DEFAULT_BUFFER 0 0 _ CATSYS.DDLCATX .0000S DEFAULT_BUFFER 0 0 _ CATSYS.DDLCATLOD .0000S DEFAULT_BUFFER 0 0 _ DBCR.BRNCHTEL .0000S DBCR_BRCH_BUFFER 0 0 _ DBCR.BRNCHTEL .0000S DBCR_BRCH_BUFFER 0 0 _ DBCR.BRNCHTEL .0000S DBCR_BRCH_BUFFER 0 0 _ DBCR.BRNCHTEL .0000S DBCR_BRCH_BUFFER 0 0 _ DBCR.ACCTHIST .0000S DBCR_ACCT_BUFFER 0 0 _ DBCR.ACCTHIST .0000S DBCR_ACCT_BUFFER 0 0 _ DBCR.ACCTHIST .0000S DBCR_ACCT_BUFFER 0 0 _ DBCR.ACCTHIST .0000S DBCR_ACCT_BUFFER 0 0 _ DBCR.ACCTHIST .0000S DBCR_ACCT_BUFFER 0 0 _ EMPDEMO.EMP-DEMO-REGION .0000S DEFAULT_BUFFER 0 0 _ EMPDEMO.INS-DEMO-REGION .0000S DEFAULT_BUFFER 0 0 _ EMPDEMO.ORG-DEMO-REGION .0000S DEFAULT_BUFFER 0 0 _ PROJSEG.PROJAREA .0000S DEFAULT_BUFFER 0 0

PM-Rnn.n SYSTEM71 CA, Inc. V71 08.348 11&col. on.02:52.67 PM-Rnn.n SYSTEM71 CA, Inc. V71 08.348 11:02:52.67 CMD--> Window : 02 02 10:30 IODT IO Detail < > Area Name Buffer Buffer Shared Cache Name Sh-Cache Waits Time Waits _ APPLDICT.DDLDML 0 .0000S 0 _ APPLDICT.DDLDCLOD 0 .0000S 0 _ CATSYS.DDLCAT 0 .0000S 0 _ CATSYS.DDLCATX 0 .0000S 0 _ CATSYS.DDLCATLOD 0 .0000S 0 _ DBCR.BRNCHTEL 0 .0000S IDMSCACHE00002 0 _ DBCR.BRNCHTEL 0 .0000S IDMSCACHE00002 0 _ DBCR.BRNCHTEL 0 .0000S IDMSCACHE00002 0 _ DBCR.BRNCHTEL 0 .0000S IDMSCACHE00002 0 _ DBCR.ACCTHIST 0 .0000S IDMSCACHE00001 0 _ DBCR.ACCTHIST 0 .0000S IDMSCACHE00001 0 _ DBCR.ACCTHIST 0 .0000S IDMSCACHE00002 0 _ DBCR.ACCTHIST 0 .0000S IDMSCACHE00001 0 _ DBCR.ACCTHIST 0 .0000S IDMSCACHE00001 0 _ EMPDEMO.EMP-DEMO-REGION 0 .0000S 0 _ EMPDEMO.INS-DEMO-REGION 0 .0000S 0 _ EMPDEMO.ORG-DEMO-REGION 0 .0000S 0 _ PROJSEG.PROJAREA 0 .0000S 0

CMD--> Window : 02 02 10:30 IODT IO Detail < Area Name Buffer Shared Cache Name Sh-Cache Sh-Cache Time Waits Time _ APPLDICT.DDLDML .0000S 0 .0000S _ APPLDICT.DDLDCLOD .0000S 0 .0000S _ CATSYS.DDLCAT .0000S 0 .0000S _ CATSYS.DDLCATX .0000S 0 .0000S _ CATSYS.DDLCATLOD .0000S 0 .0000S _ DBCR.BRNCHTEL .0000S IDMSCACHE00002 0 .0000S _ DBCR.BRNCHTEL .0000S IDMSCACHE00002 0 .0000S _ DBCR.BRNCHTEL .0000S IDMSCACHE00002 0 .0000S _ DBCR.BRNCHTEL .0000S IDMSCACHE00002 0 .0000S _ DBCR.ACCTHIST .0000S IDMSCACHE00001 0 .0000S _ DBCR.ACCTHIST .0000S IDMSCACHE00001 0 .0000S _ DBCR.ACCTHIST .0000S IDMSCACHE00002 0 .0000S _ DBCR.ACCTHIST .0000S IDMSCACHE00001 0 .0000S _ DBCR.ACCTHIST .0000S IDMSCACHE00001 0 .0000S _ EMPDEMO.EMP-DEMO-REGION .0000S 0 .0000S _ EMPDEMO.INS-DEMO-REGION .0000S 0 .0000S _ EMPDEMO.ORG-DEMO-REGION .0000S 0 .0000S _ PROJSEG.PROJAREA .0000S 0 .0000S

Screen Description

The IO Detail screen displays detailed information on database I/O waits for the current interval. The screen includes one line for each user database or secondary dictionary area defined to the DC/UCF system. For each area, the screen identifies the file and shows a breakdown of read and write I/O statistics against that file, as well as statistics related to buffer use.

Using This Screen

To request the IO History screen, press [PF9].

What To Look For

Look for average I/O times:
- Read Time divided by the number of Physical Reads
- Write Time divided by the number of Physical Writes
Average I/O times ideally should be close to the average access time for the device type that the file resides on. For example, an average response time for a 3380 device should be between 18 and 25 msec.
Look for I/O contention between database files. Your DASD configuration should isolate high activity datasets. For example:
- Isolate journals and log files
- Isolate system files from other files, such as spool files
- Spread application databases across volumes
- Isolate scratch and queue files if your system has high OLQ usage or is used for CA ADS development
Look for unexpectedly high I/O counts, which can indicate excessive fragmentation or overflow records. Use the Realtime Monitor and Application Monitor to investigate this possibility.