Bind Parameter: How to Access Data Concurrently

The new BIND parameters that help access data in highly concurrent mode.

DB2 provides data concurrency access for web applications in three ways.

Current Access Resolution

DB2 10 introduces the CURRENTACCESSRESOLUTION parameter with the USECURRENTLYCOMMITTED and WAITFOROUTCOME settings.

This parameter setting overrides the DB2 subsystem parameters of EVALUNC and SKIPUNCI and helps the application package quickly perform the desired concurrency action.

Use Currently Committed

The USECURRENTLYCOMMITTED setting instructs the system to ignore rows that are in the process of being inserted and use only currently committed rows.

This clause is contingent on the package BIND isolation level settings being either Cursor Stability or Read Stability.

Wait for Outcome

The WAITFOROUTCOME setting specifies that applicable scans must wait for a commit or rollback operation to complete when data is in the process of being updated or deleted. Rows that are in the process of being inserted are not skipped.