× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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
>



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

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

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.