Team,

create db DBUR on /db2home/DBUR/dbur_db
catalog tablespace
managed by system
using ('/db2home/DBUR/dbur_cat')
extentsize 32 prefetchsize 64
AUTOCONFIGURE USING ISOLATION UR APPLY NONE;

Does the above statement really really creates the database in isolation level UR??

I ran explain plan against the above said database.
Still..... CS is shown.


Package Context:
---------------
SQL Type: Dynamic
Optimization Level: 5
Blocking: Block All Cursors
Isolation Level: Cursor Stability


How to change to UR ??

Thanks...

-R

Isolation level only affects select statements, so I would put WITH UR at the end of each select where you want UR isolation level.

Can we create a database in UR isolation level?

We are running DB2 V8.1 FP11 on AIX
Single node database.

Is there any command to change the database isolation level to UR permanently.

Please help.

Thanks

-R

It should indeed be possible to disallow any other isolation level with a certain database.
I've never done this myself, so I don't know exactly how to do it.
This will certainly also differ from platform to platform, and from DB2 version to version.

Isolation level is what a client requests and the database 'grants' ... So, you should be setting the isolation level at the client ... Say, if you are using CLI, then you may update db2cli.ini ... if you are using Stored procs, bind the packages with ISOLATION LEVEL UR.

HTH

Sathyaram