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 JVM from bteq:
call SQLJ.ServerControl('JAVA', 'disable', a); call SQLJ.ServerControl('JAVA', 'shutdown', a); call SQLJ.ServerControl('JAVA', 'enable', a); call SQLJ.ServerControl('JAVA', 'status', a); - 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'
If the values were updated correctly on all nodes, you can conclude this process. - If the changes in the parameters were not updated on all nodes, schedule a restart of the database:
# tpareset -f force You are about to restart the database on the system 'S1' Do you wish to continue (default: n) [y,n] y
- Restart the system:
# tpareset -f forceYou 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'