I'm trying to determine if you mean %busy or %full.
If you want to find jobs with lots of I/O, that's pretty easy.
Look at ACTIVE_JOB_INFO and sort by these columns:
ELAPSED_TOTAL_DISK_IO_COUNT
ELAPSED_ASYNC_DISK_IO_COUNT
ELAPSED_SYNC_DISK_IO_COUNT
Temporary storage (from ACTIVE_JOB_INFO still)
PEAK_TEMPORARY_STORAGE
For really looking into temporary storage look at:
QSYS2.SYSTMPSTG
http://ibm.biz/DB2foriServices
Now, if you want to find out who has been writing a lot of rows to your tables, over an extended time period, and you don't care if the job is active or not, then you'll have to journal your tables and use stuff like QSYS2.DISPLAY_JOURNAL
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Justin Taylor
Sent: Wednesday, April 17, 2019 6:04 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Job behind disk utilization?
Is there a good way on IBMi 7.3 / POWER9 to determine what job(s) are driving up Disk Utilization? I don't see a correlation with CPU usage.
TIA
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com
midrange.com
