Hello Roman,

currently, when querying the MON$ATTACHMENTS table in a Firebird 2.1
database, I don't see the remote process name information for Jaybird
based connections, so it's a bit hard to find out, e.g. which Jaybird
based application has long-running transactions or something like that.

Vlad told me in firebird-support, that even Jaybird could expose the
remote process name. His original post.


<vlads_post>

> The application name is a bit of a problem if the application does not
> > use the Firebird client library from 2.1, e.g. when using Jaybird.
> >
> > Is there probably a way how Roman could make the application name
> > available in the monitoring tables?
> >
> > Possibly, the same applies to the .NET data provider as well.

Of course. They need to specify isc_dpb_process_name in DPB.
Of course, if remote server is FB 2.1 or higher, i.e. supports protocol
version 11 or above.

</vlads_post>


Possibly an useful feature for a future Jaybird release?


Thanks!


--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com