LA_SINGLESEL_ISOCS_CDY subsystem parameter
LA_SINGLESEL_ISOCS_CDY subsystem parameter specifies whether Db2 enables lock avoidance for singleton SELECT with ISOLATION(CS) CURRENTDATA (YES).
A singleton SELECT is a cursor SELECT that returns at most one row. Allowing lock avoidance can significantly lessen locking activity for such singleton SELECT statements. However, occasional false warning or error conditions are possible during certain small timing windows, such as SQLCODE -811 (more than one row returned) or SQLCODE +100 (no row found) .
| Acceptable values: | NO, YES |
|---|---|
| Default: | NO |
| Data sharing scope: | Group |
| DSNZPxxx: | DSN6SPRM.LA_SINGLESEL_ISOCS_CDY |
- NO
-
Db2 disables lock avoidance for singleton SELECT with ISOLATION(CS) and CURRENTDATA (YES). NO is the default setting.
- YES
- Db2 enables lock avoidance for singleton SELECT with ISOLATION(CS) and CURRENTDATA (YES). Important: With the YES setting, occasional false error or warning conditions are possible when lock avoidance is used for singleton SELECT statements that run with the ISOLATION(CS) and CURRENTDATA(YES) options, including SQLCODE -811 (more than one row returned) and +100 (no row found). Use this setting only if your environment can tolerate these situations.
