Default lock level

The level of record locking on the records in each database file under commitment control for the commitment definition. The level of record locking defaults to this value unless it is overridden by the system when the file is opened. You cannot override this value.

Possible values are:

Change: Protects changed records from changes by other jobs running at the same time. For retrieved records, or rows, the lock is held for the duration of the LUW.
Cursor stability: Protects both changed and retrieved records, or rows, from changes by other jobs running at the same time. Retrieved records, or rows, that are not changed are protected only until they are released, or a different record, or row, is retrieved.
All: Protects changed records, or rows, and retrieved records, or rows, that are under commitment control from changes by other jobs running under commitment control at the same time. Records, or rows, that are retrieved or changed are protected until the next commit or rollback operation.