Chapter 11. Performance tuning of DB2 UDB Workgroup Server 375
Locking options
DB2 UDB offers options in the area of locking. The options help to reduce DB2
UDB resource consumption for the lock list memory area and reduce the chance
of lock escalation for the entire database or an individual database agent.
The LOCKSIZE of the table can be changed from the default of row level locking
to table level locking through the ALTER TABLE statement. This allows
read-only tables to hold less DB2 UDB lock resources (as share locks behave
the same at the table or row level) due to the fact that one lock (at the table level)
is all that is required on the table. Depending on the isolation level setting, this
can reduce the memory consumption within the ...