RE: DB2EUG: Knock off idle users and sessions

[Pedron, Leo]

Title: Knock off idle users and sessions

Take a look at using the DB2 Governor.  You’ll find a little doc in the in Command Ref, but the details are in the Admin guide.  I’ve used the governor to in the past to exactly this sort of thing.  As far as tuning is concerned, I’d start by using the db2batch tool to examine your SQL and the snapshot monitor to watch over your bufferpool hit ratios and sorts.    HTH, Leo   -----Original Message----- From: Sireesh Chandra M, STC Chennai [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 19, 2001 11:18 AM To: [EMAIL PROTECTED] Subject: DB2EUG: Knock off idle users and sessions   Hi All,         I need to knock off idle users or sessions, say if the session is idle for 10 minutes or so, from the database. How do i do that??I have DB2 UDB V6.1 EE for Windows Nt. Also, does anyone have a good document on implementing tuning (both application and database parameters).?? If so, can you share that with me. Thanks and Regards Sireesh.