Re: Finding historical number of interactive jobs -- MIDRANGE-L

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