Skipping Locked Rows [DB2 9 for z/OS]

(Craig Mullins) In DB2 9 it is possible for a transaction to skip over rows that are locked. This can be accomplished by means of the SKIP LOCKED DATA option within your SQL statement(s). SKIP LOCKED DATA can be specified in SELECT, SELECT INTO, and PREPARE, as well as searched UPDATE and DELETE sta

Read More - Register for Free Membership