current number of outstanding transactions?

["Lee, Jessie" <Je...@bmc.com>]

Hi, All,
 
I tried to find out how many outstanding transactions are still there
before I shutdown my derby database.  Is there a system function or
trigger (or Java API) that I can use to retrieve the information?
 
Thanks,
Jessie Lee

Re: current number of outstanding transactions?

[Jessie Lee <je...@bmc.com>]

Thank you very much, Suresh.  This is exactly what I need.  I was using an 
older version of derby which didn't have this table.

Thanks again,
Jessie

Re: current number of outstanding transactions?

[Suresh Thalamati <su...@gmail.com>]

Lee, Jessie wrote:
> Hi, All,
>  
> I tried to find out how many outstanding transactions are still there 
> before I shutdown my derby database.  Is there a system function or 
> trigger (or Java API) that I can use to retrieve the information?
>  
> Thanks,
> Jessie Lee

Hi,

I am not aware of any derby API that will return the out-standing 
transactions. For debugging purposes, there is a inmemory 
syscs_diag.transaction_table,  that contains the transaction 
information. "select * from  syscs_diag.transaction_table" will list 
the transaction information. Note that , this information is just a 
snapshot ,it is always possible after system takes the snapshot of the 
transaction table, some other transaction became active

Not sure, if you can use the information provided by this table in an 
application. syscs_diag.transaction_table is meant for debugging 
purposes , It may change in the future releases.


Thanks
-suresh