Re: Job behind disk utilization?

[Charles Wilt <charles.wilt@xxxxxxxxx>]

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