I replaced the WRKSYSACT with:
Command . . . . . . . . . . RUNSQL REQUEST('SELECT JOB_NAME , ELAPSED_CPU_PERCE
NTAGE FROM TABLE (QSYS2.ACTIVE_JOB_INFO(''YES'','''','''','''')) AS X ORDER BY E
LAPSED_CPU_PERCENTAGE DESC')
Command . . . . . . . . . . RUNSQL REQUEST('SELECT JOB_NAME , ELAPSED_CPU_PERCE
NTAGE FROM TABLE (QSYS2.ACTIVE_JOB_INFO(''NO'','''','''','''')) AS X ORDER BY EL
APSED_CPU_PERCENTAGE DESC')
I have to call this twice.
First with reset "Yes"
Second with reset "No"
Does this make sense?
I am now seeing valid output.
JOB_NAME ELAPSED_CPU_PERCENTAGE
---------------------------- ----------------------
969792/PRODUCT/QSJSENDER 50.0
969869/PRODUCT/SYSCPAMOB 13.1
905271/QSYSOPR/HALAX1 10.1
969669/CPAHSTRA/LOADMOPWRK 9.4
968133/CHADTASS/QPADEV0061 1.3
968585/CHAJFREE/QPADEV00BM .8
968183/CHAJCORT/QPADEV001G .8
969683/CLEMOSTR/QPADEV00FG .4
968211/TPAJHORN/PALBOCS18B .1
990833/ZENDADMIN/ZC_STR_ASJ .1
494462/QSYS/BATCH_CM .0
Paul
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Justin Taylor
Sent: Tuesday, January 10, 2017 10:06 AM
To: Midrange Systems Technical Discussion
Subject: RE: CPU monitor >90% for 5 minutes - attach to the alert the jobs and/or tasks causing the issue.
So that limitation is inherent in WRKACTJOB?
-----Original Message-----
From: Rob Berendt [mailto:rob@xxxxxxxxx]
Sent: Tuesday, January 10, 2017 6:30 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: RE: CPU monitor >90% for 5 minutes - attach to the alert the jobs and/or tasks causing the issue.
From the Knowledge Center:
<snip>
The information returned is similar to the detail seen from the Work with Active Jobs (WRKACTJOB) command.
</snip>
See also:
https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/IBM%20i%20Technology%20Updates/page/QSYS2.ACTIVE_JOB_INFO()%20-%20UDTF
Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at
http://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:
http://amzn.to/2dEadiD
midrange.com
