RE: Finding historical number of interactive jobs

All good options mentioned.

Another quick method is wrksyssts, select assistance level 1=Basic

Users:
Signed on . . . . . . . . . . . . . . . . . . . . . . . : 470
Temporarily signed off . . . . . . . . . . . . . . . . . : 0
Suspended by system request or group jobs . . . . . . . : 5
Signed off with printer output waiting to print . . . . : 56147

Paul

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Vern Hamberg
Sent: Thursday, August 26, 2021 12:14 PM
To: midrange-l@xxxxxxxxxxxxxxxxxx
Subject: Re: Finding historical number of interactive jobs

________________________________
CAUTION: This email originated from outside of the PENCOR network. Do not click on any links or open attachments unless the sender is known, and the content is verified as safe.
________________________________

Hi Bryan

I like the use of the history log service - I assume you are not saying that this is the performance data route, right? Just trying not to confuse too much!!

A couple thoughts - not all interactive jobs necessarily run in a
QINTER* subsystem. I think there's a job type in the log record.

The actual job start time is in the message data, as well. Not the end, though CPF1124 shows only the starting data.

CPF1164 gives the ending data - I believe that the starting data is buried in there, but you'd want both the 24 and 64, so that you catch currently active ones. Part of the challenge is the overlaps of job life.

Regards
Vern

On 8/26/2021 7:58 AM, Bryan Dietz wrote:

I agree on the performance data route

I've used the following SQL to get a count of "job starts" per day per
hour.

SELECT day(Message_Timestamp) AS day_started
,hour(Message_Timestamp) AS hour_started
,COUNT(from_job) as jobs
FROM TABLE(Qsys2.History_Log_Info(
Start_Time => current_timestamp - 3 days,
End_Time =>  current_timestamp
)) i
WHERE Message_Id = ('CPF1124')
AND MESSAGE_TEXT LIKE '%subsystem QINTER%'
GROUP BY Grouping Sets (
(
hour(message_timestamp)
,day(message_timestamp)

) -- "Detail"
,(day(message_timestamp)) -- subtotal
,() -- Grand Total
)
ORDER BY day_started ;

or you could just run this as often as needed:

select count(*) from TABLE
(Qsys2.Active_Job_Info(Subsystem_List_Filter => 'QINTER'));

Bryan


Jack Kingsley wrote on 8/26/2021 4:39 AM:

If your collecting performance data, it is probably in there as well.

On Wed, Aug 25, 2021 at 7:18 PM Vern Hamberg
<vhamberg@xxxxxxxxxxxxxxx>
wrote:

Hi Bill

You might have info in the history files - the QHST* files - there
is an SQL service for displaying those. Basically you want, I think,
to get start and end of each interactive job - CPF1124 and CPF1164,
IIRC, are the messages used for start and end - CPF1164 might have
the start time in it, too.

Now people often have cleanup clear these history files, so you
might need to build this up over time.

Just an idea for you!

Regards
Vern

On 8/25/2021 10:55 AM, Howie, Bill wrote:

Hello all,

Wondering if anyone out there has had the need in the past to
figure out

the maximum number of concurrent QINTER sessions going back 30 days?
I was looking at some of Scott Forstie's stuff but haven't stumbled
across anything. As always any info is greatly appreciated.

[Related image]<https://www.hc-companies.com/>Bill Howie Senior ERP
Programmer/Analyst
Direct: 330.487.3739 | Cell: 330.888.8085 | Toll Free: 800.225.7712
2450 Edison Blvd, Suite 3, Twinsburg OH 44087
hc-companies.com<https://www.hc-companies.com/>
Leader in Horticultural Containers
[cid:image003.png@01D799A7.95D5BD80]<

https://www.linkedin.com/company/the-hc-companies>
[cid:image004.png@01D799A7.95D5BD80] <
https://www.facebook.com/HCCompanies/>
[cid:image005.png@01D799A7.95D5BD80] <
https://www.instagram.com/hccompanies/>
[cid:image006.png@01D799A7.95D5BD80]
<https://twitter.com/hc_companies>

Disclaimer

The information contained in this communication from the sender is

confidential. It is intended solely for use by the recipient and
others authorized to receive it. If you are not the recipient, you
are hereby notified that any disclosure, copying, distribution or
taking action in relation of the contents of this information is
strictly prohibited and may be unlawful.

This email has been scanned for viruses and malware, and may have
been

automatically archived by Mimecast Ltd, an innovator in Software as
a Service (SaaS) for business. Providing a safer and more useful
place for your human generated data. Specializing in; Security,
archiving and compliance. To find out more visit the Mimecast
website.

--
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.

Help support midrange.com by shopping at amazon.com with our
affiliate
link: https://amazon.midrange.com

--
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.

Help support midrange.com by shopping at amazon.com with our affiliate link: https://amazon.midrange.com