hi GBagalkot

Isolation level changes are not permitted while connected to a database with
a type 1 connection (see SET CLIENT). The back end process must be
terminated before isolation level can be changed:
db2 terminate
db2 change isolation to ur
db2 connect to sample
Changes are permitted using a type 2 connection, but should be made with
caution, because the changes will apply to every connection made from the
same command line processor back-end process. The user assumes
responsibility for remembering which isolation level applies to which
connected database.

ref: https://aurora.vcu.edu/db2help/db2n0/frame3.htm#sqln0025

regards
thiru

> -----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.
>
>
> ---------------------------------------------------------------------
> 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]
>


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