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.

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