Hi The problem I'm trying to solve is users leaving inactive db_workbench sessions attached to a database while other work is going on by other processes, causing a large OIT gap and the consequent problems. The solution needs to be automatic and unattended.
db_workbench doesn't have a timeout setting (I asked) deleting the row from mon$statements doesn't kill the transaction; deleting the row from mon$transactions or mon$attachments gives "operation not supported" I could automate a kill of the fb_inetserver process but I would rather something with less risk I figure other people have had this and solved it before, I hope. currently using firebird 2.1 on centos, shortly moving to 2.5
