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

You can make use of db2 governor.

Regards
Prakash

Hello I don't know which version you're on
but if yoy're on 8.1.0 or later you can:

1. use: "db2 get snapshot for locks on <mydb>"

2. see which applications are holding the locks you want released

3. use: "force application <applicationid> to get rid of the agents

In general dissuade your developers from using persistent connections.

HTH