468,104 Members | 1,293 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

Setting a specific Isloation Level at a Database Level

I have several Databases in a Instance . I want to a set particular
Isolation Level for Only one read Only Database . Is it Possible to set
a specific Isloation Level at a Database Level

May 31 '06 #1
2 1292
Ranjit,

You can't set the Isolation Level at the database level. Every db2
client connection has its own isolation level.

Regards,

Mehmet Baserdem

May 31 '06 #2
Ranjit,
I am not sure if the isolation can be set at the database level....
But, u can surely find a working alternative...
Isolation level can be specified at various level
.. At precompile or bind time
If u have your own bind file, isolation level is stored in it.

.. At statment level
Use the with clause with every sql statement.

.. From CLI or ODBC at run-time
From DB2 call level interfaces u can changes the isolation level as part of the db2 cli cfg parameter. You can use the TXNISOLATION keyword
in the db2cli.ini file for the same

..JDBC or SQLJ runtime
JDBC & SQLJ are implemented with CLI in DB2, which means db2cli.ini cfg
setting might apply.You can use the setTransactionIsolation method of
java.sql interface connection.
Depending on ur needs u can opt for path to change the isolation level.
(Default is CS for most)


Ra************@gmail.com wrote: I have several Databases in a Instance . I want to a set particular
Isolation Level for Only one read Only Database . Is it Possible to set
a specific Isloation Level at a Database Level


Jun 1 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by John Hargrove | last post: by
1 post views Thread by Suresh | last post: by
1 post views Thread by Jerad Rose | last post: by
1 post views Thread by Solo | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.