Subject | Re: [firebird-support] Two transactions can have the same TID? |
---|---|
Author | lcampbell |
Post date | 2013-09-18T19:00:22Z |
On 9/9/2013 1:29 PM, Norman Dunbar
wrote:
Norman,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
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?