Re: ODBC performance problems

[vhamberg@xxxxxxxxx]

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.
>