HP OpenVMS Systems

Meaning of ENQLM quotas, parameters?

» close window

The Question is:

 
Where can I find a explanation of what changes to PQL_DENQLM, and PQL_MENQLM
 will mean to my system. What are the tradeoffs involved? What do these numbers
 really mean in terms that someone who is DBA/Sys Admin can understand? Is
 there a "Distributed Locks for Dummies" book?
 

The Answer is :

 
  These parameters establish the default and minimum numbers of locks
  that all processes can utilize.  For well-behaved application programs,
  increasing these parameter values will have negligible effects.
 
  Database packages are commonly consumers of large numbers of locks, and
  can have numerous locks queued from each process -- accordingly, databases
  can require large settings of the ENQLM process quotas and/or large values
  for the system parameters PQL_*ENQLM.
 
  What does this mean for you?  Not much.  Set the system parameters and
  process quotas per the specifications of the database vendor.  (Most of
  the available database packages are well-behaved applications.)
 
  From the SYSGEN help text:
 
Sys_Parameters
 
  PQL_MENQLM
 
       PQL_MENQLM sets the default limit on the minimum number of locks
       that can be queued at one time by a process created by the
       Create Process ($CREPRC) system service or the DCL command RUN
       (Process).
 
       PQL_MENQLM has the DYNAMIC and GEN attributes.
 
Sys_Parameters
 
  PQL_DENQLM
 
       PQL_DENQLM sets the default enqueue limit for a process created
       by the Create Process ($CREPRC) system service or the DCL command
       RUN (Process).
 
       PQL_DENQLM has the DYNAMIC and GEN attributes.
 
 

  

     

     
answer written or last revised on ( 8-JUN-2001 )
     
» close window