Changing CufConfig Parameter Values - Teradata Vantage

Teradata Vantageā„¢ - Bring Your Own Model User Guide

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Vantage
Release Number
5.0
Published
October 2023
Language
English (United States)
Last Update
2024-04-06
dita:mapPath
fee1607120608274.ditamap
dita:ditavalPath
ayr1485454803741.ditaval
dita:id
fee1607120608274
PrerequisiteYou must be logged on as the root user.
  1. Create a file, filename.txt, with one line for each cufconfig parameter whose value you want to change.
    Each line has this syntax: parameter: value
    For 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
    • This line increases the JVM memory size and the cache size:
      JVMOptions: -Xms2048m -Xmx8192m -DcacheMaxLimit=3g

      The value of cacheMaxLimit is in GB.

      For more information about these parameters, see Configuration and Tuning Settings.

  2. Run this command:
    cufconfig -f filename.txt
  3. 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
  4. 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'