That should work, we are running fixpak 4 (version 8,aix) here, and that
does the trick. You can also use the "set isolation level ur" prior to
issuing the select. I believe there is also a clp command (if that is where
you are issuing the command from) to change the isolation "db2 change
isolation to ur".

Cliff.

-----Original Message-----
From: GBagalkot
[mailto:db2udbdba-ezmlmshield-x38511292.[Email address protected]
Sent: Wednesday, June 23, 2004 11:08 PM
To: LazyDBA Discussion
Subject: Cannot set the isolation level UR


Hi,
I have a strange situation. Need some help.
I executed the db2expln command on a simple SELECT
statement [select * from emp where emp_id=10]. In the
output it said the isolation level as Cursor Stability
[CS]. This is fine.
But when I did the same thing with the sql statement
as
"select * from employee where emp_id=10 with UR"
Then also in the output it said the isolation level as
Cursor Stablility.
Is this an expected output? If yes, how to put the
SQLs in UR level. This I executed on the system where
the server is installed. [AIX, DB2 8.1]
Regarding the knowledge what I am missing. I was
thinking that by putting the isolation level in the
SQL statement, we can control the isolation levels.
But this disproves that.
Pls advice me.
Thanks
Girish.



__________________________________
Do you Yahoo!?
Yahoo! Mail - Helps protect you from nasty viruses.
http://promotions.yahoo.com/new_mail


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: db2udbdba-[Email address protected]

*************************************************************
This message, including any attachments, may contain
confidential information intended for a specific individual
and purpose, and may be protected by law. If you are not
the intended recipient, please notify the sender by e-mail
or telephone immediately, and then immediately delete this
message. Any disclosure, copying or distribution of this
message, or the taking of any action based on it, by any
unintended recipient is strictly prohibited.

DB2 & UDB email list listserv db2-l LazyDBA home page