It you
use MTS(Microsoft) for transaction pooling, you can setup in the configuration
to automatically force off per your specifications. You can code your own
spooling enging in ODBC (we have one system that used C++). However, this
has to be carefully coded, spooled ODBC connections
can sometimes orphan after a force at the application & DB end
(db2 7.2 EEE (& EE?) . You end up having to kill, which of course
renders your DBMS into crash recovery at first query. DB2 is very good at
healing itself, though.
Regarding performance:
IBM has a good redbook(IBM research team free dwnloadable
documentations) out on Performance tuning search www.redbooks.ibm.org
There
were also several tuning presentations at the Florida IDUG event that had some
great presenters that discussed performance tuning (including IBM's Bernie
Shafer, several members of this listserve and guess who :) ).. www.idug.org
Another freebie:
Check
out the DB2 performance configuration wizard. In DB2 Control Center
right click your database name. You can save the recommended config, you
don't have to apply right away.
-----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 sessionsHi 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.
