Re: QDZASOINIT

[Alexei Pytel <pytel@xxxxxxxxxx>]

One possibility is that application creates a new connection for each 
query and never closes it.

    Alexei Pytel





"Steven DONNELLAN" <steven@xxxxxxxxxxxxxxxxxxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
02/06/2004 01:52 PM
Please respond to Midrange Systems Technical Discussion
 
        To:     <midrange-l@xxxxxxxxxxxx>
        cc: 
        Subject:        QDZASOINIT


We have a programmer who is using JDBC to access AS/400 data from a
'web' front end.  Every time he executes a Query to get data from the
AS/400 a job is started called QDZASOINIT.  One of these is created for
every Query (eg 1 for getting the Customer Details, another for getting
the Customer Transaction History etc etc).  The problem we have got is
that these jobs don't end, and the number of them grows at an alarming
rate affecting all over system performance.  Is this a known problem
with OS/400, or something that the programmer is doing wrong?  We are
V5R2, and coding in MS J++.  Code snippets would be nice, as I don't
speak Java, and it would help me get a better understanding of what's
going on at the client side.
PS, thanks to those of you who responded to me earlier this week on my
original Java question
 
Steven Donnellan
=========================================
This email has been scanned for viruses, because I care!
=========================================
 
_______________________________________________
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.