× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.