I keep seeing in the manuals that the default is cursor stability, yet our
seems to be repeatable read. On the AIX server I placed the TXNISOLATION=2
in the db2cli.ini file and had no luck, so I added CURSORHOLD=0 in the
db2cli.ini file as well to see what that will do. I had a program bound
and it is still defaulting to repeatable read. Do I need to stop any
services or anything for this to take? Also, I need to state that these
programs are being bound from a S/390 environment to the UDS environment.
Thanks,
Tim
----- Forwarded by Tim Traxson/Corporate/JBHunt on 03/12/2003 04:34 PM
-----
"Reys, Ellen"
<[EMAIL PROTECTED] To: "'[EMAIL PROTECTED]'"
<[EMAIL PROTECTED]>
m> cc: "'[EMAIL PROTECTED]'" <[EMAIL
PROTECTED]>
Subject: RE: [DB2EUG] Setting the
default isolation level.
03/12/2003 04:26
PM
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
