Specifying the default maximum number of locks per table space

The NUMLKTS subsystem parameter specifies the default value at the subsystem level for the LOCKMAX clause of CREATE TABLESPACE and ALTER TABLESPACE statements.

• Set the NUMLKTS subsystem parameter value.
  In most cases, you can use the default or continue using the existing value if you are migrating from a previous Db2 release. The NUMLKTS value should be less than the value for the NUMLKUS subsystem parameter, unless the value of the NUMLKUS subsystem parameter value is 0.
• When you create or alter a table space, especially when you alter one to use row locks, use the LOCKMAX clause explicitly for that table space.