Lock Governor (-LGovernor)

Operating system and syntax UNIX Windows 
-LGovernor n
Use with Maximum value Minimum value Single-user default Multi-user default
DBS 100 0 – 0
n
The percent of the lock table one tenant can occupy.

Lock Governor (-LGovernor) specifies the percentage of the lock table that a tenant can occupy. Lock governor prevents a tenant from acquiring all the locks in a table. Lock governor applies to the default tenant and regular tenant. This governor does not apply to super-tenants and non multi-tenant databases.

When a tenant attempts to acquire more locks than the governor allows, an error message is displayed and recorded in the database log as: 

Attempt to exceed tenant lock governor for tenant <tenantID>. Increase -L or -LGovernor.

You can set or modify the -LGovernor value using the PROMON utility.

To change this parameter while the database is running, use PROMON or the _DbParams VST.

You can use this parameter to support continuous operation of the database. For more information, see Change database parameters while the database is running.