> On 9/9/2013 1:29 PM, Norman Dunbar wrote: >> >> Evening Lane, >> >> On 09/09/13 16:21, lcampbell wrote: >> > OK, this is scary. How do I query the TID to determine if my DB is >> > approaching the limit? >> >> SQL> select MON$NEXT_TRANSACTION from mon$database; >> >> MON$NEXT_TRANSACTION >> ==================== >> 785 >> >> or >> >> $ fbstat -h employee | grep -i "next transaction" >> Next transaction 785 >> > Norman, > Is this a Linux thing? I'm running Win7; when I try the above query in > either DB Workbench or at the isql command line, I get 'Table > MON$DATABASE not found.' Am I doing something wrong?
You need a database with an ODS 11.1 or higher. -- With regards, Thomas Steinmaurer http://www.upscene.com/ Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc.
