In our application we want to do the dirty read ( read_uncommited) in some of the select queries where the output of the query is not important. But at the same time we want to avoid any possible locking while read.
For eg.
Just to check whether table exists or not , we are using
"select count(*) from tableName"
Now here we can allow dirty read to avoid any db locking.

In MSSQLServer db, this query can be written
"select count(*) from tableName with (NOLOCK)"
in sybase it can be written
"select count(*) from tableName AT ISOLATION 0"

What is the equivalent for the same in IBM-db2 database ?

WITH UR

like

select * from table1 WITH UR

HTH

Sathyaram

Thank you very much ,

One more query related to lockhint ...

What is the equivalent to "READPAST" lockhint of MSSQLServer/Sybase in IBM-DB2 ?

Sorry ... I have no idea what READPAST mean ...

Can you explain please

Sathyaram

Readpast lockhint guarantees to give only committed records
but will automatically skip records that are being
inserted or updated.

This way we can avoid any possible locking while select and also make sure that dirty reads are not happening.

For eg,
I have 2 parallel Tx , in one tx i'm updating the row 5 and row 7 and in second tx i'm doing the select from row 1 to row 10.
Without readpast , select query will be locked untill update is over, but with readpast, it will give me 8 rows skipping 2 rows being updated.

SQLServer and Sybase has this facility in which lock is obtained while read as well.
Is there anything similar we can use for DB2, because I have seen in DB2 as well in such scenarios locking will happen.

No I don't think you can do it in DB2.