In clp, issue the command "change isolation level to CS" prior to performing connection.
On Windows, modify the /sqllib/cli.ini file, using the TXNISOLATION keyword. TXNISOLATION= /* look on the web what the setting should be for the CS */ CURSORHOLD=0 http://www-3.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/v8infoce nter.d2w/report?target=mainFrame&fn=t0005269.htm Ellen Klebaner-Reys Data Management Services Inovant - a Visa Solutions Company [EMAIL PROTECTED]/650-432-1746 m/s: 3125-1D -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 12, 2003 1:41 PM To: [EMAIL PROTECTED] Subject: [DB2EUG] Setting the default isolation level. We have programmers that are binding programs and not specifying any isolation levels in the bind. The default appears to be repeatable read. I am wanting to change this to cursor stability. Anyone know how to change the default isolation level? DB2 version 7.2 fixpack 4 on AIX. DB2 version 7.2 fixapck 6 on Windows. Thanks, Tim - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc
