Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2004
    Posts
    111

    Arrow Unanswered: Create Db... Isolation Ur

    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

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Isolation level only affects select statements, so I would put WITH UR at the end of each select where you want UR isolation level.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Sep 2004
    Posts
    111

    Arrow

    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

  4. #4
    Join Date
    Sep 2004
    Location
    Belgium
    Posts
    1,126
    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.
    --_Peter Vanroose,
    __IBM Certified Database Administrator, DB2 9 for z/OS
    __IBM Certified Application Developer
    __ABIS Training and Consulting
    __http://www.abis.be/

  5. #5
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    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
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •