Hi Thiru and all,
Thansk for the replys. Question that came to my mind
is ' How to identify the which type of connection the
client is using'.
Thanks
Gbag
--- Thirumaran
<db2udbdba-ezmlmshield-x89600367.[Email address protected]
wrote:
>
> 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]
> >
>
>
>
>
---------------------------------------------------------------------
> 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]
>
>
__________________________________
Do you Yahoo!?
Yahoo! Mail Address AutoComplete - You start. We finish.
http://promotions.yahoo.com/new_mail
DB2 & UDB email list listserv db2-l LazyDBA home page