SQL$HELP_OLD72.HLB  —  ALTER  DATABASE  Arguments  LOCK_PARTITIONING
    Syntax options:

    LOCK PARTITIONING IS ENABLED | LOCK PARTITIONING IS DISABLED

    Specifies whether more than one lock tree is used for the
    database or all lock trees for a database are mastered by one
    database resource tree.

    When partitioned lock trees are enabled for a database, locks for
    storage areas are separated from the database resource tree and
    all locks for each storage area are independently mastered on the
    VMScluster node that has the highest traffic for that resource.
    OpenVMS determines the node that is using each resource the most
    and moves the resource hierarchy to that node.

    You cannot enable lock partitioning for single-file databases.
    You should not enable lock partitioning for single-node systems,
    because all lock requests are local on single-node systems.

    By default, lock partitioning is disabled.
Close Help