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


The above fbstat is what gstat is called in Linux Mint. Your
installation might well still be called gstat.


HTH

--
Norman Dunbar
Dunbar IT Consultants Ltd

Registered address:
27a Lidget Hill
Pudsey
West Yorkshire
United Kingdom
LS28 7LG

Company Number: 05132767