cur_commit - Currently committed configuration parameter
This parameter controls the behavior of cursor stability (CS) scans.
- Configuration type
- Database
- Parameter type
- Configurable
- Configurable by member in a Db2® pureScale® environment
- Default [range]
- ON [ON, AVAILABLE, DISABLED]
For new databases, the default is set to ON. When the default is set to ON your query will return the currently committed value of the data at the time when your query is submitted.
During database upgrade from V9.5 or earlier, the cur_commit configuration parameter is set to DISABLED to maintain the same behavior as in previous releases. If you want to use currently committed on cursor stability scans, you need to set the cur_commit configuration parameter to ON after the upgrade.
You can explicitly set the cur_commit configuration parameter to AVAILABLE. Once you set this parameter, you need to explicitly request for currently committed behavior to see the results that are currently committed.