CONCURRENTACCESSRESOLUTION bind option
The CONCURRENTACCESSRESOLUTION option specifies which concurrent access resolution option to use for statements in a package.
| CONCURRENTACCESSRESOLUTION |
|
On: BIND and REBIND
PLAN and PACKAGE, REBIND TRIGGER PACKAGE
|
- ( USECURRENTLYCOMMITTED )
- Specifies that when a read transaction requires access
to a row that is locked by an INSERT or DELETE operation, the database
manager can access the currently committed row, if one exists, and
continue to the next row. The read transaction does not need to wait
for the INSERT or DELETE operation to commit. This clause applies
when the isolation level in effect is cursor stability or read stability. Under the following circumstances, if USECURRENTLYCOMMITTED
is specified for a package, WAITFOROUTCOME behavior is used instead:
- The table space on which the package operates is not a universal table space.
- XML data is being selected, and the data does not support multiple XML versions. In this case, the DB2® database manager cannot determine whether the data has been committed.
- ( WAITFOROUTCOME )
- Specifies that when a read transaction requires access
to a row that is locked by an INSERT or DELETE operation, the read
transaction must wait for a COMMIT or ROLLBACK operation to complete.
Defaults:
| Process | Default value |
|---|---|
| BIND PLAN | None |
| BIND PACKAGE | None |
| REBIND PLAN | None |
| REBIND PACKAGE | None |
| REBIND TRIGGER PACKAGE | None |
CONCURRENTACCESSRESOLUTION has no default. The following table shows how DB2 handles uncommitted INSERTs for all combinations of CONCURRENTACCESSRESOLUTION settings and subsystem parameter SKIPUNCI settings.
| SKIPUNCI value | CONCURRENTACCESSRESOLUTION value | Skip uncommitted INSERTs or wait for COMMIT or ROLLBACK |
|---|---|---|
| YES | USECURRENTLYCOMMITTED | Skip uncommitted INSERTs |
| YES | WAITFOROUTCOME | Wait for COMMIT or ROLLBACK |
| YES | Not specified | Skip uncommitted INSERTs |
| NO | USECURRENTLYCOMMITTED | Skip uncommitted INSERTs |
| NO | WAITFOROUTCOME | Wait for COMMIT or ROLLBACK |
| NO | Not specified | Wait for COMMIT or ROLLBACK |