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.


This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].