> 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.