Thanks Jim - I think this might get me what I need in the short term. Maybe I will work on reading the spool file and writing the data to a database for long term analysis
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Jim Carlin
Sent: Tuesday, June 14, 2011 9:17 AM
To: Midrange Systems Technical Discussion
Subject: Re: QZDASOINIT start/stop logging
Based on your prestart settings, you can then schedule to capture how many you’re processing at intervals with this command (automate in a CLP, etc.):
DSPACTPJ SBS(QUSRWRK) PGM(QZDASOINIT) OUTPUT(*PRINT)
You may need to do DSPACTPJ SBS(QUSRWRK) PGM(QZDASOINIT) and take option F13 to reset your statistics.
You can then trend your data of peaks and valleys vs. DSPLOG.
Just a thought.
Jim
----- Original Message -----
From: "Mike Cunningham" <mike.cunningham@xxxxxxx>
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Sent: Tuesday, June 14, 2011 9:04:35 AM
Subject: RE: QZDASOINIT start/stop logging
Did that already. That will show a log of connections made but does not tell me when there were insufficient QZDASOINIT jobs to service a request and more needed to start and see of that need to start more correlates with when a user reports they can't get connected
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Tuesday, June 14, 2011 8:35 AM
To: Midrange Systems Technical Discussion
Subject: Re: QZDASOINIT start/stop logging
DSPLOG JOB(QZDASOINIT)
Rob Berendt
--
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
From: Mike Cunningham <mike.cunningham@xxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 06/14/2011 08:20 AM
Subject: QZDASOINIT start/stop logging Sent by: midrange-l-bounces@xxxxxxxxxxxx
Is there any way to see when and how often the number of QZDASOINIT database server jobs in QUSRWRK start and stop? Or the additional jobs threshold is reached and more need to be started. We are getting some random occurrence of an app running on a linux server making ODBC connections saying it timed out getting a database connection. By the time we get the report and investigate the problem has gone away. We don't know for sure of the QZDASOINIT jobs are the problem but it is one place that needs looked at.
Thanks
--
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.
--
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.
--
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.
--
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.
midrange.com
