470,607 Members | 2,357 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,607 developers. It's quick & easy.

How to change the isolation level of a database alias


We use db2connect and DRDA to communicate between an AS400 and DB2 UDB V7.2.
We have a new needs with an AS400 library that we already used with the
isolation level "CS"; now we want to use it sometime with isolation level
"UR" in an application an sometimes with isolation level "CS" as usual.
We don't use ODBC over db2connect, only db2connect.
The command "db2 change isolation to UR" works correctly in the windows
command but not in the application we use (bug reported).

We have created a database Alias with the client configuration assistant
which is based on the same target database that the first alias we already

Now we're looking for the commands and parameters to change the default
isolation level for this new alias.

Does someone know these commands and parameters ?

Best Regards,

Romain F.
Nov 12 '05 #1
0 1701

This discussion thread is closed

Replies have been disabled for this discussion.

By using this site, you agree to our Privacy Policy and Terms of Use.