Hi Anuj,

Do you have security auditing enabled on your installation?

If not enable it, then connect to iidbdb and issue the command:
enable security_audit user;\g

You can then follow the users connect and disconnect in the iiaudit
catalog. I havent tested this - but I'm pretty sure that if someone does
not disconnect correctly you'll see only a TERMINATE message and
not a disconnect.

Marty
> Dear Marty,
>
> We have a large number of users (charcter terminal based applications
> and web based query screens) during day time and a lot of batch jobs
> during night. I have been trying to locate the user session(s) which
> might not be disconnecting properly. It is not an easy job.
>
> With regards,
>
> Anuj.
>
> On Thu, 18 Jan 2007, martin.bowes@ctsu.ox.ac.uk wrote:
>
> > Hi Anuj,
> >
> > Is your application disconnecting from databases correctly? It
> > doesn't look like it is, hence the large number of
> > E_GC2205_RMT_ABORT messages. I would suggest trying to elliminate
> > those messages and I wouldn't mind betting that the others may go
> > away.
> >
> > Marty
>