Re: Finding historical number of interactive jobs

Yes, you can get this data from Collection Services.

There was a stated requirement that the information is needed for the prior 30 days.
Most shops have the Collection Services data retention set at the default of 10 days for Standard Data (the data in the Db2 files).

To meet the 30 day requirement, you’d need some sort of process that pulls the required data out of the CS files and builds a table of the data you want on an ongoing basis.

The QAPMJOBMI file has a record of every active job that used CPU in the interval. It also keeps track of when the jobs ended. The Job Type - JBTYPE - of I identifies interactive jobs.

With the 30-day requirement, it may be easiest to use the history log messages.


(As an aside, if you are using iDoctor, once you have analyzed a Collection Services Collection to gather Job Counts, you can review Job Counts by Subsystem; if you know the subsystems of interest, you can see the number of jobs in that subsystem over time. This has the same limitation as above - it’s one collection, generally 24 hours. This may be useful for a daily review, but would not meet the requirement of the prior 30 days).

Dawn

On Aug 26, 2021, at 8:58 AM, Bryan Dietz <bdietz400@xxxxxxxxx> 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