RE: Job behind disk utilization?

[Justin Taylor <JUSTIN@xxxxxxxxxxxxx>]

I'm looking at disk activity (i.e. I/O), rather than storage.



-----Original Message-----
From: Charles Wilt [mailto:charles.wilt@xxxxxxxxx] 
Sent: Wednesday, April 17, 2019 5:20 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: Job behind disk utilization?

Assuming you're talking temp storage...

Then ACS Run SQL scripts has 3 examples that look at temp storage for a job...

Here's the simplest...
--  category:  IBM i Services
--  description:  Work Management - Active Job Info - Temp storage top consumers
--
-- description: Find active jobs using the most temporary storage.
--
SELECT job_name
       ,authorization_name
       ,temporary_storage
       ,sql_statement_text
       ,j.*
    FROM TABLE(qsys2.active_job_info(detailed_info => 'ALL')) j
    WHERE job_type <> 'SYS'
    ORDER BY temporary_storage DESC;

Charles


On Wed, Apr 17, 2019 at 4:03 PM Justin Taylor <JUSTIN@xxxxxxxxxxxxx> wrote:

> 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