Change database parameters while the database is running

For primary broker parameters, use the _Dbparams VST. For example, you can use ABL code like this to set the value of the LRU force skips parameter (-lruskips) to 100 :

Find _dbParams 
   where _dbParams-Name = "-lruskips".
   assign _dbParams-Value = 100.

For the secondary broker parameters, use the _Servers VST. You need the index number for each parameter you want to change. Use a command like this to retrieve the index numbers:

DEF VAR i AS INT.
FOR EACH _Servers  WHERE _Server-Pid <> 0:
DISPLAY
  _Server-type FORMAT "x(8)" LABEL "Type".
  REPEAT i = 1 TO 64:    
    IF (_SrvParam-Name[i] = ?) THEN 
     LEAVE.
    ELSE
     DISPLAY 
     i LABEL "Index" //This is the index of SrvParam-Value & _SrvParam-Name    
    _SrvParam-Name[i] format "x(22)" label "Name"
    _SrvParam-Value[i] format "x(8)" label "Value"
    _SrvParam-dtype[i]  label "DataType"
    _SrvParam-Is-Modifiable[i] label "Mod"
    _SrvParam-Is-Default[i] label "Def".
  END.
END.

     Index Name                   Value    DataType Mod Def
---------- ---------------------- -------- -------- --- ---
         1 -ipver                 IPV4            1 no  no
         2 -maxport               2000            4 yes yes
         3 -minport               1025            4 yes yes
         4 -ssj                   1               3 yes yes
         5 -threadedServer        1               3 no  yes
         6 -threadedServerStack   512             4 no  yes
         7 -Ma                    1               4 yes no
         8 -Mi                    1               4 yes yes
         9 -Mm                    8192            4 yes yes
        10 -Mp                    0               4 no  yes
        11 -Mpb                   5               4 yes no
        12 -N                     TCP             1 no  yes
        13 -PendConnTime          0               4 yes yes
        14 -S                     22202           1 no  no
        15 -ServerType            BOTH            4 no  no
        16 -SQLCursors            50              4 no  yes
        17 -SQLLockWaitTimeout    5               4 no  yes
        18 -SQLQuotedRowid        1               1 no  no
        19 -SQLStack              1000            4 no  yes
        20 -SQLStmtCache          100             4 no  yes
        21 -SQLTempBuff           1000            4 no  yes
        22 -SQLTempDisk           500000          4 no  yes
        23 -SQLTempPageSize       8               4 no  yes
        24 -SQLTruncateTooLarge   OFF             1 no  yes
        25 -SQLWidthUpdate        OFF             1 no  yes

To update a parameter, use this syntax:

Find _Servers where _Server-Id = serverId.  
_SrvParam-Value[serverParamIndex] = serverParamValue.

For example, to change the value of Maximum Servers per Broker (-Mpb) to 20, use the following, because the index value for -Mpb is 11:

Find _Servers where _Server-Id = 2.  
_SrvParam-Value[11] = 20.

In the .lg file, a confirmation message appears:

(5647) Maximum Servers Per Broker (-Mpb): 20