Hello Neil,

> We would be connected from Delphi and all our clients are on 2.1. But before I get this implemented in code I would like to see it in SQL.
>
> I have tried in both IBQuery and isql but whenever I run the following:
>
> select * from MON$ATTACHMENT;
>
> I always get an error that the table is unknown.
>
> Should I be able to run that statement from isql?

Yes, but it's MON$ATTACHMENTS and not MON$ATTACHMENT, sorry. This also
requires a database with an ODS 11.1 or higher database. To check the
ODS, e.g. use gstat -h or AFAIR a:

SHOW DATABASE;

in isql shows the ODS as well.


So, if you are connecting with a 2.1 server to an older (pre ODS 11.1)
database, the monitoring tables aren't available. To upgrade a database
to the server ODS, run a backup with the old Firebird server and a
restore with 2.1.

HTH.


--
With regards,
Thomas Steinmaurer

* Upscene Productions - Database Tools for Developers
http://www.upscene.com/

* My Blog
http://blog.upscene.com/thomas/index.php

* Firebird Foundation Committee Member
http://www.firebirdsql.org/en/firebird-foundation/

> Thanks
>
> Neil
>
> --- In firebird-support@yahoogroups.com, Thomas Steinmaurer<ts@...> wrote:
>>
>> Hi Neil,
>>
>>> Thanks for the quick response.
>>>
>>> I have a few further questions...
>>>
>>> When I try and select from this table I get a message to say that it doesn't exist. I am logged in as sysdba - do I need to do anything else?
>>>
>>> My db is 2.1.3.18185 and the GDS32.dll is version 6.3.3.18185
>>>
>>> I assume that the remote process property has to be set as part of the connection string?
>>>
>>> And finally, I assume that this is available via an api?
>>
>> The following is from the 2.1 release notes.
>>
>> - columns MON$REMOTE_PID and MON$REMOTE_PROCESS contains non-NULL values
>> only if the client library is version 2.1 or higher
>>
>> - column MON$REMOTE_PROCESS can contain a non-pathname value if an
>> application has specified a custom process name via DPB
>>
>> But I know from Jaybird for instance, that one needs to specify specific
>> properties, see:
>> http://tracker.firebirdsql.org/browse/JDBC-118
>>
>> But I guess this is related to the thin driver not communicating via the
>> client library.
>>
>>
>> What access technology do you use and is your mentioned gds32.dll
>> version the one on the client or do we speak about a local installation
>> here anyway?
>>
>> --
>> With regards,
>> Thomas Steinmaurer
>>
>> * Upscene Productions - Database Tools for Developers
>> http://www.upscene.com/
>>
>> * My Blog
>> http://blog.upscene.com/thomas/index.php
>>
>> * Firebird Foundation Committee Member
>> http://www.firebirdsql.org/en/firebird-foundation/
>>
>>
>>> Thanks
>>>
>>> Neil
>>> --- In firebird-support@yahoogroups.com, Thomas Steinmaurer<ts@> wrote:
>>>>
>>>> Neil,
>>>>
>>>>> I know that it is possible to see who is currently connected to a database but is it possible to see how they have connected?
>>>>>
>>>>> By which I mean is it possible to see whether they are connected from, say, IBConsole, IBQuery or an application?
>>>>
>>>> MON$REMOTE_PROCESS in MON$ATTACHMENT, but AFAIK this needs at least V2.1
>>>> of the client libraries.
>>>>
>>>>
>>>> --
>>>> With regards,
>>>> Thomas Steinmaurer
>>>>
>>>> * Upscene Productions - Database Tools for Developers
>>>> http://www.upscene.com/
>>>>
>>>> * My Blog
>>>> http://blog.upscene.com/thomas/index.php
>>>>
>>>> * Firebird Foundation Committee Member
>>>> http://www.firebirdsql.org/en/firebird-foundation/
>>>>
>>>
>>>
>>>
>>>
>>> ------------------------------------
>>>
>>> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>>>
>>> Visit http://www.firebirdsql.org and click the Resources item
>>> on the main (top) menu. Try Knowledgebase and FAQ links !
>>>
>>> Also search the knowledgebases at http://www.ibphoenix.com
>>>
>>> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>>> Yahoo! Groups Links
>>>
>>>
>>>
>>
>
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>