More on this for the book. Granted it's for AIX but a lot of it applyies to NT also. At least you can get very good ideas. I have been to the site but maybe there's also one for NT?? DB2 UDB V7.1 Performance Tuning Guide Abstract . This IBM Redbook will provide you with guidelines for system design, database design, and application design with DB2 UDB for AIX Version 7.1. We will also discuss the methods that are available for performance analysis and tuning. Prior to reading this book, you need to have some knowledge of database environments, as well as a basic understanding of activities that are typically performed in a database environment. This book was written from the AIX operating system perspective, and some tools and commands discussed in this book may not be available on other operating systems. However, the hints and methodologies described in this book can be applicable for database systems which use DB2 UDB on other operating systems. HTML version at: http://www.redbooks.ibm.com/redbooks/SG246012.html Scott Saunders wrote: > Sireesh;You can use the DB2 Governor for this purpose. You can set > an IDLE rule with FORCE action to force the thread after a specified > amount of idle time. Details are in the DB2 Admin Performance > GuideHTH; > > Regards, > Scott Saunders > Siebel Systems, Inc. > > Opinions expressed are my own and not those of my employer. > > -----Original Message----- > From: Sireesh Chandra M, STC Chennai > [mailto:[EMAIL PROTECTED]] > Sent: Thursday, July 19, 2001 8: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. >
begin:vcard n:Saint-Jacques;Pierre tel;cell:514-233-8679 tel;fax:514-737-1268 tel;work:514-737-4515 x-mozilla-html:FALSE org:SES Consultants Inc. adr:;;233 Simcoe Cr.;Mount-Royal;QC;H3P 1X1;Canada version:2.1 email;internet:[EMAIL PROTECTED] title:President fn:Pierre Saint-Jacques end:vcard
