Hi,

I invited you to read DB2 documentation on isolation level, in DB2 you have 4 isolation levels and what you see depends on the level used


Stéphane Paquette
Administrateur de bases de données
Database Administrator
Standard Life
www.standardlife.ca
Tél. (514) 499-7999 poste 7470 stephane.[Email address protected] <mailto:stephane.[Email address protected]



-----Original Message-----
From: Vasan Subramanian
[mailto:db2udbdba-ezmlmshield-x17182682.[Email address protected]
Sent: 28 octobre, 2004 10:36
To: LazyDBA Discussion
Subject: Reg:- Locks


Hi,

In Sql server, when we write a select on a table, we used to give 'nolock' on that table so that no shared locks are put on that table.

Like the foll :-
select cust_code,cust_name
from customer_master (nolock)
where cust_code = @cust_code

Is there any approach in DB2 like that ??

Please advise me about how to see the logiacl reads in DB2.


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


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