Re: ODBC performance problems

[ouuch@xxxxxxxxxxx]

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