RE: Nav Custom Charts & Disk Response (Justin Taylor)

This information is available from Collection Services. The file
is QAPMSMDSK which may be in QPFRDATA library or maybe somewhere else.
Unfortunately this file contains members, which usually change every 24
hours at midnight, but may be different.
To read members with SQL an ALIAS must be created, which would have to be
changed to the new member every day (or other timescale).
Here is the SQL that you can use in Custom Charts

Run once after the member name changes, where xxxxxxxxx is todays number
(creates a *FILE object in MYLIB)

create alias MYLIB.DSKR_TODAY for QPFRDATA.QAPMSMDSK (Qxxxxxxxxx);

The SQL below assumes the Collection Services update Disk Info every 5
minutes. You can place both Read and Write metrics on one Custom Chart.
You should also change the default refresh the same time interval as the
SQL e.g. 5 minutes.

For Disk Reads

select
double(SMDTRRSPT / SMDTROPS / 1000.00)
as DISK_READ_RSPNS
from MYLIB.DSKR_TODAY
where (SMDBDD = '01')
and time(DATETIME) between
current time - 5 minutes and current time
fetch first 1 row only;

For Disk Writes

select
double(SMDTWRSPT / SMDTROPS / 1000.00)
as DISK_WRITE_RSPNS
from MYLIB.DSKR_TODAY
where (SMDBDD = '01')
and time(DATETIME) between
current time - 5 minutes and current time
fetch first 1 row only;

Regards
Terry