31.03.2017 01:11, Leyne, Sean wrote:
>
> One of my developers was looking for a simple way to determine what
> Process was the current DB operation related to.
>
> I knew that MON$Attachments has a MON$Remote_Process value, so I
> expected the same details would be available thru
> RDB$Get_Context("SYSTEM",....) call. But I was wrong.
RDB$GET_CONTEXT('SYSTEM', 'CLIENT_PID')
RDB$GET_CONTEXT('SYSTEM', 'CLIENT_PROCESS')
> There are several MON$Attachments columns which are not available, thru
> the "SYSTEM" namespace:
> - MON$SERVER_PID
> - MON$STATE
> - MON$REMOTE_PID
> - MON$CHARACTER_SET_ID
> - MON$TIMESTAMP
> - MON$GARBAGE_COLLECTION
> - MON$REMOTE_PROCESS
> - MON$STAT_ID
>
> Is there a reason why the values could not be added to "SYSTEM" namespace?
We add them on demand, based on user requests. I don't think all of them
are really needed.
Dmitry
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
