Clean Inactive Transactions

[SivaSivaSivaSiva]

Hello,

In my database many connections are opened by application, and they are still remaining eventhough the application developers shutdown their machines. They are not properly closing their application before shutdown. So those connections remain in the database and sometimes it locks the tables also.We couldn't findout from which machine, the table was locked and how to force(kill) only that application?
Is there anyway to clean the oldest transaction which are not active for say 15 minutes?

Regards,
Siva

 

[blom0344]

Hello 4x Siva,

Though I have little experience with it myself, setting up DB2 governor should give you some sort of control over connections and settings.

Look in Administration guide: Performance for the chapter on the DB2 Governor

T. Blom
Information analyst
tbl@shimano-eu.com