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?
