VST _DbParams-Name '-nap' and '-napmax' are modifiable but value changes are not applied

VST _DbParams-Name '-nap' and '-napmax' are modifiable in the VST _DbParams._DbParams-is-modifiable but value changes are not applied.

DO TRANSACTION:
FIND FIRST _DbParams WHERE _DbParams._DbParams-Name = "-nap".
ASSIGN _DbParams._DbParams-value = "3". /* [default 10] initial latch sleep time (10 to 500) */
END.

DO TRANSACTION:
FIND FIRST _DbParams WHERE _DbParams._DbParams-Name = "-napmax".
ASSIGN _DbParams._DbParams-value = "9". /* [default 250] Maximum latch sleep time (10 to 10000): */
END.

DEFINE VARIABLE cPmsgs AS CHARACTER NO-UNDO INITIAL 
'-nap,-napmax'.

DEFINE VARIABLE ix AS CHAR NO-UNDO. 
DEFINE VARIABLE ii AS INT NO-UNDO.

DO ii = 1 TO NUM-ENTRIES(cPmsgs):

ASSIGN ix = (entry(ii,cPmsgs)). 

FOR FIRST _DbParams NO-LOCK WHERE _DbParams._DbParams-Name = ix.

IF AVAILABLE _DbParams THEN 
DISPLAY _DbParams._DbParams-Name _DbParams-Is-Modifiable _DbParams-Value SKIP.

END.
END.

 

Database Startup parameters that can be updated in PROMON can almost all be updated with the associated  _DbParams VST and the value change is applied (as long as it's valid). 

The _DbParams-Name '-nap' and '-napmax' values were being changed to a value outside of the range validation check:

• -napmax: [default 250] Maximum latch sleep time (10 to 10000)
• -nap: [default 10] initial latch sleep time (10 to 500)

Lower or higher values than the PROMON range validation for -nap -napmax can be specified at database startup.

Examples:  

// verify -nap -napmax have changed with a query on the same
// _DbParams can only be used to modify -nap -napmax within the valid range
// -napmax 10 to 10000
// -nap 10 to 500

DEFINE VARIABLE cPmsgs AS CHARACTER NO-UNDO INITIAL 
'-nap,-napmax'.

DEFINE VARIABLE ix AS CHAR NO-UNDO. 
DEFINE VARIABLE ii AS INT NO-UNDO.

DO ii = 1 TO NUM-ENTRIES(cPmsgs):

ASSIGN ix = (entry(ii,cPmsgs)). 

FOR FIRST _DbParams NO-LOCK WHERE _DbParams._DbParams-Name = ix.

IF AVAILABLE _DbParams THEN 
DISPLAY _DbParams._DbParams-Name _DbParams-Is-Modifiable _DbParams-Value SKIP.

END.
END.

 

Progress Articles:
000110929
How to change the Commit Lock Skip Limit for the TXE in promon?