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 [email protected], 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 [email protected], 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 > > >
