CONCURRENTACCESSRESOLUTION bind option
The CONCURRENTACCESSRESOLUTION option specifies which concurrent access resolution option to use for statements in a package.
Command option | Option values | Used with |
---|---|---|
CONCURRENTACCESSRESOLUTION |
|
Note:
- The CONCURRENTACCESSRESOLUTION bind option is not valid for REBIND of packages for native SQL procedures or advanced triggers.
Option descriptions for CONCURRENTACCESSRESOLUTION
- ( 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.
Default values for CONCURRENTACCESSRESOLUTION
Process | Default value |
---|---|
BIND SERVICE | None |
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 |