Subject Re: [firebird-support] Two transactions can have the same TID?
Author lcampbell
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?