Re: ODBC performance problems

["Paul Nelson" <p_nelson-br@xxxxxxxxxxxx>]

Most likely not closing the connections when it is finished, or it's timing
out and retrying.

Paul Nelson
Braxton-Reed, Inc.
630-327-8665 Cell
708-923-7354 Home
pnelson@braxton-reed.com
----- Original Message -----
From: <vhamberg@attbi.com>
To: <midrange-l@midrange.com>
Sent: Tuesday, October 22, 2002 6:33 PM
Subject: Re: ODBC performance problems


> Each QZDASOINIT job is associated with a connection. The
> NT app could be opening multiple connections, or not
> closing some.
>
> HTH
>
> Vern
> > Hello,
> >
> > On 22 Oct 2002 at 17:35, Paul Nelson wrote:
> >
> > > How many users are firing off these jobs? Normally, you'll get one
> > > qzdasoinit job per user, but the gotcha is that if they get impatient,
> > > or if they kill the query midstream, it can leave many instances of
> > > the qzdasoinit job running. Been there, seen that.
> > >
> >
> > No, it is only a one-to-one connection. The NT-server is controlling a
sorting
> > machine. The
> > AS/400 puts ready records into the file, the NT-server polls the file
and
> > updates the records
> > when its finished sorting.
> >
> > Basically, the NT does a select * from vrosif where sistat ='41' and
further
> > updates on single
> > records (by order number).
> >
> > During normal operations, there's only one qzda* job running for this
odbc
> > connection.
> >
> > Any other suggestions,
> >
> > Thanx,
> >
> > Oliver
> > _______________________________________________
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> > To post a message email: MIDRANGE-L@midrange.com
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> > or email: MIDRANGE-L-request@midrange.com
> > 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@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> or email: MIDRANGE-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>
> _____________________________________________________
> This message scanned for viruses by CoreComm
>