UPDATE_LOCK_TYPE=

UPDATE_LOCK_TYPE=

Specifies how a DB2 table is locked during an UPDATE operation.

Default value: ROW

Syntax
Details
See Also

Syntax

UPDATE_LOCK_TYPE= ROW | TABLE

Details

If you specify ROW, the locking is determined by the UPDATE_ISOLATION_LEVEL= setting. If you specify TABLE, the entire table is locked in exclusive mode.

For a full description of this option, refer to UPDATE_LOCK_TYPE= .

See Also

READ_LOCK_TYPE=

Chapter Contents
Previous
Next
Top of Page