Firebird - transaction monitoring

Question

I updated my Firebird to the versão 2.5 and would like to view the transactions, I saw in several links that the command: SELECT * FROM mon$statements solves, but this command gives me a mistake:

Undefined name. Dynamic SQL Error. SQL error code = -204. Table Unknown. MON$STATEMENTS. Unknown ISC error 336397208

So I understand that he does not find this table, he can also, because my connection is directly inside a database that does not have this "table" mon$statements, so how to proceed ?

Answer 1

Using the code below will bring as a response all transactions initialized. So you can identify the one that is causing you problems.

SELECT    
    mon$transaction_id,
    mon$attachment_id,
    mon$state,
    mon$timestamp,
    mon$top_transaction,
    mon$oldest_transaction,
    mon$oldest_active,
    mon$isolation_mode,
    mon$lock_timeout,
    mon$read_only,
    mon$auto_commit,
    mon$auto_undo,
    mon$stat_id,
    case mon$isolation_mode
       when 0 then 'Consistency'
       when 1 then 'Concurrency'
       when 2 then 'Read Committed Record Version'
       when 3 then 'Read Committed'
       else 'Unknown'
    end as Desc_Isolation,
    case MON$LOCK_TIMEOUT
       when -1 then 'Infinite Wait'
       when  0 then 'No wait'
       else 'Timeout ' || cast(MON$LOCK_TIMEOUT as varchar (20))
    end as Desc_TimeOut
from mon$transactions
order by 1