PrerequisiteYou must be logged on as the root user.
-
Get the current parameter values to modify.
cufconfig -o | grep 'parameter'
For example:# cufconfig -o | grep 'JVMOptions' JVMOptions: -XX:+UseBCFIPS
-
Create a file, filename.txt, with one line for each cufconfig parameter whose value you want to change.
Each line has this syntax: parameter: valueFor example:
- These lines change the memory and cache to the maximum values in Recommended Java Server Settings for BYOM Sessions:
ParallelUserServerAMPs: 50 ParallelUserServerPEs: 50 SecureServerAMPs: 120 SecureServerPEs: 120 JavaHybridThreads: 50 JavaServerTasks: 50
If the parameter takes multiple values, and you want to preserve them, append the current values to the new ones.
- For example, this line increases the JVM memory size and the cache size:
JVMOptions: -Xms2048m -Xmx8192m -DcacheMaxLimit=3g
The resulting line in filename.txt should be as follows:JVMOptions: -XX:+UseBCFIPS -Xms2048m -Xmx8192m -DcacheMaxLimit=3g
The value of cacheMaxLimit is in GB.
For more information about these parameters, see Configuration and Tuning Settings.
- These lines change the memory and cache to the maximum values in Recommended Java Server Settings for BYOM Sessions:
-
Run this command:
cufconfig -f filename.txt
-
Restart the system:
# tpareset -f force
You are about to restart the database on the system 'S1' Do you wish to continue (default: n) [y,n] y
-
Check the new parameter values:
cufconfig -o | grep -iE 'parameter[|parameter]'
For example, to show the values of the parameters ParallelUserServerAMPs and ParallelUserServerPEs:cufconfig -o | grep -iE 'paralleluserserveramps|paralleluserserverpes'