272 DB2 UDB V8 and WebSphere V5 Performance Tuning and Operations Guide
reporting applications, if the answer set does not have to be exact (but rather an
approximation), UR might be the proper isolation level. There are actually very
few instances where the RR isolation level is required, and the application
requirements should be verified to confirm that RR isolation is necessary (due to
the potential for lock waits and lock escalation).
Locking options
DB2 UDB offers options in the area of locking 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 ...