|
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.
 |
|
|
|
|
