I have two thread..
1) Thread 1 selects the top record (status = 0) and places an exclusive lock on it, but allows read past and obtains ID.

2) Thread 2 selects the top record (status = 0) and can’t select Thread 1’s record because its locked but instead of being blocked is allowed to read past the current locked record to the next record

for this "select *from table with(updlock,readpast) where status=0" is used in SQL server but, I want the same functionality in DB2. Could anybody help me on this, its urgent as I am not getting it in google.