Controlling XML lock escalation

You can use the LOCKMAX clause of the ALTER TABLESPACE statement to control the number of locks that are acquired within a particular XML table space before the lock is escalated.

Procedure

Begin program-specific programming interface information.

Specify the LOCKMAX option of the ALTER TABLESPACE statement.

When the total number of page, row, and XML locks reaches the maximum that you specify in the LOCKMAX clause, the XML locks escalate to a gross lock on the XML table space, and the XML locks are released

Information about XML locks and lock escalation is reported in IFCID 0020. End program-specific programming interface information.