|
Andy, The polling application does work against the AS400 DB2 database. As the server has 40 modems connected to it , I would have thought that only 40 concurrent connections could be made. If each modem opened a single connection , can I reasonably say that this modem can make 200 connections before the QZDASOINIT job is ended and another takes its place. (is that basically how it should work?) > Message: 3 > From: "Andy Nolen-Parkhouse" <aparkhouse@attbi.com> > To: <midrange-l@midrange.com> > Subject: RE: QZDASOINIT > Date: Wed, 3 Apr 2002 07:59:58 -0500 > Reply-To: midrange-l@midrange.com > > Steven, > > Assuming that the polling application is initiating the jobs, QZDASOINIT > is processing a JDBC request against your database and then returning > the results to your program. I am assuming that your polling > application works against a DB2 database. Is it possible that your > application has around 800 database connections open concurrently? I'm > not a Java coder so I don't know much about whether a database > connection needs to be explicitly closed within the application. The > QZDASOINIT program will process IP-based database requests from other > sources as well as JDBC. > > The maximum number of uses (200) specifies how many times a pre-start > job can be reused before the subsystem ends the job. You can assume > that the 800 jobs did not reach this limit. If it is reasonable for > your application to have this number of database connections active, > then what you are seeing is reasonable. You might want to increase the > initial number of jobs, the threshold, and the additional jobs parameter > so that more jobs are created less frequently. > > Regards, > Andy _____________________________________________________________________ This message has been checked for all known viruses by UUNET delivered through the MessageLabs Virus Control Centre. For further information visit http://www.uk.uu.net/products/security/virus/
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 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].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.