Re: Nav Custom Charts & Disk Response

[Justin Taylor <jtaylor.0ab@xxxxxxxxx>]

:(  Well that's not very practical.  Daily change would be bad enough, but
mine changes twice a day.

Thanks


date: Wed, 27 Apr 2022 00:00:56 +0100
> from: Terry Bartlett <terry.bartlett@xxxxxxxxxxxxxxx>
> subject: 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