Database Software

Hello:

my Timesten is few slow, so I am using ttxactadmin comman with -interval option.
I see a transaction that it seems it does not finish.

Program File Name: ttcserver
Client machine: btmxgw01 (btmxgw01); IP address: 10.100.192.240; Client PID: 21938;

21021 0x109d7a60 222.25901810 Active Database 0x01312d0001312d00 IX

Some TimesTen technical people told me that
222.25901810 Active is the transaction ID on database.

many times, thos transactions are not show frecuently on the ttxactadmin output. I mean those transaction are finished too fast, but in this case this "transaction ID" has been shown on my ttxactadmin for a long time ( I thing more than 1 hour), but I could not identify something like a session id on database in order to kill this session.

I have gotten a trace using tttracemon trying to identify such transaction id, in order to catch the statement that is executing on that moment, But it could be helpful if timesten could show session id for database connections and you could killl or stop that applications which cuold be locking some object.

Finally, I could not stop my application, because those sessions are generateb by threads, so one client process starts many threads connextios to Timesten.
Each thread works as an independient process into database.

Regards.