SQL$HELP_OLD72.HLB  —  ALTER  DATABASE  Arguments  ADJUSTABLE_LOCK_GRANULARITY
    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, ENABLED, 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.
    You can trade more restrictive locking for less CPU usage in such
    databases by disabling adjustable lock granularity.
Close Help