Syntax options:

       ADJUSTABLE LOCK GRANULARITY IS ENABLED
       ADJUSTABLE LOCK GRANULARITY IS DISABLED

 Enables or disables whether or not the database system automatically
 maintains as few locks as possible on database resources. The
 default is ENABLED and results in fewer locks against the database.
 However, if contention for database resources is high, the automatic
 adjustment of locks can become a CPU drain. Such databases can trade
 more restrictive locking for less CPU usage by disabling adjustable
 lock granularity.