Setting a specific Isloation Level at a Database Level

[RanjitSingh.RS]

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

[Mehmet Baserdem]

Ranjit,

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

Regards,

Mehmet Baserdem

[Peri]

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