With all this, I think it's easy to kill a long query on the server (with a
small application that the administrator can run on the server):

- Just find out the user IP address and force 'close connection' on the
server. Is this ok to do? The user will get some message from the
application (if the application could detect net faults), but the
administrator will have the problem of a long query running resolved.

I have adapted Vadim Crits utility IbConsvc to do this (I must write him a
email first - I don't know if he will allow me to change this code), and put
it available to the community. I find it very useful to kill connections
when we don't want any user around....

Artur

----- Original Message -----
From: <lester@...>
To: <ib-support@yahoogroups.com>
Sent: Thursday, February 28, 2002 7:23 AM
Subject: Re: [ib-support] Re: Canceling Queries


> > > Unlike IB5, in IB6 it works pretty good, (provided you are connected
via
> > tcp/ip)
> > > i.e. server will notice that the client is dead and cancels
> > > execution of query (even if it is in the middle of sorting).
> >
> > I didn't know about this, and it's a big help. Is it documented in some
> > place? It's enough to kill the connection and connect again?
>
> I view this as one of the MAJOR bugs in IB5.X which was
> fixed in IB6. My problem was ( and still is ) flaky network
> connections. On IB5 the server end connections just stacked
> up until the server went belly up, unless you did a
> stop/start to clear things down regularly. With IB6, never
> seen that problem.
>
> Deliberate 'kills' of a process are just the same thing.
>
> I think it is documented on the closed bug list - but stand
> to be corrected.
>
> --
> Lester Caine
> -----------------------------
> L.S.Caine Electronic Services
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
>