Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2004

    Unanswered: Inactive threads - how to automatically terminate them?


    We're running UDB 7.1 (yes, upgrade is on its way) on Solaris. I have a number of users using DB2 command center to connect to the database and they often don't terminate their session at the end of the day after issuing a SELECT that can return a large result set. Therefore, the locks are never released and the online application sometimes fails to insert into the database because the transaction log is full.

    Is there any config parameter that will cause DB2 to terminate those threads when they go inactive for a given time period ?


  2. #2
    Join Date
    Jun 2003
    Toronto, Canada
    Provided Answers: 1
    I think you can use DB2 Governor utility to disconnect idle and/or long-running applications.

Posting Permissions

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