RE: Limiting ODBC connections for a user

I have setup a subsystem just for this one external system to use. That is all working well. All ODBC jobs are being routed to the new subsystem. With the new subsystem I now have some additional tuning options to try and control these jobs from taking over the system. There is a setting on the prestart jobs for the subsystem on how many QZDASOINIT jobs to allow to start and there is a setting for Max Active on the new subsystem. Is there any guideline for how to set these two controls for this type of workload? Currently prestart jobs are set to allow 200 and max active is set at 35. Is it better to accept a connection and not let it run (high QZDASONINT and low Max Active) or is it better to set these two at about the same number. I know if QZDASOINIT is to low the application times out and shows the user a connection error and if it is high they just don't get a response back for a long time

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Charles Wilt
Sent: Tuesday, July 31, 2012 2:50 PM
To: Midrange Systems Technical Discussion
Subject: Re: Limiting ODBC connections for a user

You can route specific ODBC/JDBC users to a specific subsystem...

http://www.centerfieldtechnology.com/PDFs/August-2005-Newsletter.PDF

HTH,
Charles

On Tue, Jul 31, 2012 at 2:41 PM, Mike Cunningham <mike.cunningham@xxxxxxx> wrote:

We have a system running on a linux box making ODBC connections to the iSeries to get DB2 data. At times that system gets used heavily and we see 50-60 ODBC jobs at one time using CPU time. They all connect as the same user over ODBC. Is there a way to limit the number of jobs that QZDASOINIT will start for a particular user? We have other jobs, including native java apps that also use QZDASOINIT but as a different user. The java connections never cause problems and we don't want to limit those.
--
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.