Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Posts
    8

    Unanswered: Clean Oldest Transactions

    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

  2. #2
    Join Date
    Feb 2002
    Posts
    96
    You can make use of db2 governor.

    Regards
    Prakash

  3. #3
    Join Date
    Feb 2004
    Location
    Copenhagen
    Posts
    220

    Arrow Force

    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
    Kristian K. Hansen
    Project Supervisor
    National Board of Health

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •