Re: Processor usage

SQL: Yes, there are SQL (assuming later release and PTF groups) interfaces. The easiest way to figure them out is to start Navigator, go to the performance pages, pick the chart you like, then use the icon in the upper right hand corner to get a copy of the SQL Navigator is using.

Providing you have sufficient authority WRKSYSACT will also allow you to monitor it.. The best thing to do is just set up Navigator to monitor it for you and then alert you if there is an event you care about.


--
Jim Oberholtzer
Agile Technology Architects

On Aug 27, 2025, at 8:59 AM, DEnglander--- via MIDRANGE-L <midrange-l@xxxxxxxxxxxxxxxxxx> wrote:

According to IBM, we have a six core Power 9 with all 6 cores active.
However, when I enter DSPLICKEY, it shows our Usage limit is 3, which I
believe means at most, we can only use up to 3 cores without paying
additional.

Other than the CPU Percentage on WRKSYSSTS or WRKACTJOB, is there any way
[preferably SQL] to see what the average usage percent is for the 3 cores
that are active? For example I need to see if we are, on average, running
an 85% load on the 3 cores, or if we are running, on average a 35% load on
the three cores, or somewhere in between?

Thank you,

Doug



"CONFIDENTIALITY NOTICE: This e-mail transmission (and/or the attachments accompanying it) contain confidential information belonging to the sender. The information is intended only for the use of the intended recipient. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or the taking of any action in reliance on the contents of the information is strictly prohibited. Any unauthorized interception of this transmission is illegal under the law. If you have received this transmission in error, please promptly notify the sender by reply e-mail, and then destroy all copies of the transmission."
--
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@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.