Access to currently committed data

In DB2® 10 new-function mode, you can access currently committed data to dramatically minimize transaction suspension.

Now, a read transaction can access the currently committed and consistent image of rows without being blocked, even if the rows are incompatibly locked by write transactions. This new capability provides flexibility and increased performance to applications that require only available and committed data to be returned from DB2 tables.

Start of change This new function is supported by a new bind option, CONCURRENTACCESSRESOLUTION, and two new PREPARE statement clauses, USE CURRENTLY COMMITTED and WAIT FOR OUTCOME, which you can specify in the attribute-string. In addition, this function is supported by the new SKIPUNCI subsystem parameter. End of change

Start of change Access to currently committed data is available only on universal table spaces and applies only to row-level and page-level locks. End of change