15.00 - Version - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
15.00
Content Type
Configuration
Publication ID
B035-1102-015K
Language
English (United States)
Last Update
2018-09-25

Version

Purpose  

Specifies the version of the UDF GDO. The version only changes when new fields are added or modified.

Note: This field should not be modified.

Scenarios Examples

Example  

To display the cufconfig help, type the following:

cufconfig -h

The following appears:

 _______
    |                                |              |
    |    ___     __     ____         |    ____    __|__    ____
    |   /      |/  \    ____|    ____|    ____|     |      ____|
    |   ---    |       /    |   /    |   /    |     |     /    |
    |   \___   |       \____|   \____|   \____|     |__   \____|
 
    Release 14.00.00.00 Version 14.00.00.00  
    UDF GDO Configuration Utility (Mar 2006)
 
 
 
cufconfig may be used from the dbw
or from the command line
 
valid options:
-o
   outputs the gdo to the screen.
-i
   initializes the gdo to the defaults.
-f filename
   modifies the gdo fields identified
   in filename. Fields not specified in filename
   will not be set or reset by this tool.
 
Note that if several options are specified
they are analyzed in the following order:
-i -f -o
 
If only a few fields need to be set differently than
the defaults, specify the -i option with the -f option.
Use the -o option to verify the settings.
 
 
Exiting cufconfig...

Example  

To display the contents of the UDF GDO, type the following:

cufconfig -o
Version: 7
ModTime: 1308613095
SWDistNodeID: 33
SourceDirectoryPath: /etc/opt/teradata/tdconfig/Teradata/tdbs_udf/usr/
CompilerTempDirectory: /var/opt/teradata/tdtemp/UDFTemp/
UDFLibraryPath: /etc/opt/teradata/tdconfig/udflib/
CompilerPath: /usr/bin/gcc
LinkerPath: /usr/bin/ld
UDFServerMemPath: /var/opt/teradata/tdtemp/udfsrv/
MaximumCompilations: 10
UDFServerTasks: 2
SecureServerAMPs: 20
ParallelUserServerAMPs: 2
SecureServerPEs: 20
ParallelUserServerPEs: 2
TDSPLibBase: /etc/opt/teradata/tdconfig/tdsplib/
UDFLibPath:
UDFIncPath:
UDFEnvFile:
CLILibPath: /opt/teradata/client/14.00/lib64
CLIIncPath: /opt/teradata/client/14.00/include
CLIEnvFile:
JavaLibraryPath: /etc/opt/teradata/tdconfig/jarlib/
JREPath: /opt/teradata/jvm64/jre8/jre/
JavaLogPath: /tmp/
JavaEnvFile:
JavaServerTasks: 2
JavaHybridThreads: 20
JavaVersion: 0x10004
JavaBaseDebugPort: 0
JSVServerMemPath: /var/opt/teradata/tdtemp/jsvsrv/
MallocLimit: 33554432
GLOPLockTimeout: 130
GLOPLockWait: 120
MaximumGLOPSize: 256
MaximumGLOPMem: 2560
MaximumGLOPPages: 8
GLOPMapMemPath: /var/opt/teradata/tdtemp/udfglopdata/

Example  

Note: Before you begin, make sure your computer has a minimum of 256 KB of free disk space to run the protected or secure mode server process. Each server process requires 256 KB of space.

Do the following steps to modify the fields of the UDF GDO:

1 Open a new text file, or open an existing UDF configuration file.

2 In a text editor, type the fields and field values you want to modify. For example:

UDFServerTasks:10
ParallelUserServerAMPs:4
ParallelUserServerPEs:4
UDFEnvFile: /home/sally/config/udf/UDFEnvFile.txt
CLILibPath: /opt/teradata/client/14.00/lib64
CLIIncPath: /opt/teradata/client/14.00/include
CLIEnvFile: /home/sally/config/CLI/CLIEnvFile.txt
JavaBaseDebugPort: 8000
JavaLogPath: /tmp/
JavaEnvFile: /home/sally/config/jvm/jvmenv.txt
JavaServerTasks: 10

Note: The field names are case sensitive and must follow the same format as the output from the -o option. The UDF configuration file should contain only the fields you want to modify, with each field on a separate line as shown above.

3 Save the UDF configuration file as a text file. For example, save the file as:

4 Use the -f option to modify the UDF GDO with the field values specified in the UDF configuration file, and use the -o option to display the updated contents of the UDF GDO.

Using the UDF GDO contents in “Example 2,” if you apply the field changes from this example, the new output of the UDF GDO would be the following:

Version: 6
ModTime: 1206484172
SWDistNodeID: 33
SourceDirectoryPath: /etc/opt/teradata/tdconfig/Teradata/tdbs_udf/usr/
CompilerTempDirectory: /var/opt/teradata/tdtemp/UDFTemp/
UDFLibraryPath: /etc/opt/teradata/tdconfig/udflib/
CompilerPath: /usr/bin/gcc
LinkerPath: /usr/bin/ld
UDFServerMemPath: /var/opt/teradata/tdtemp/udfsrv/
MaximumCompilations: 10
UDFServerTasks: 10
SecureServerAMPs: 20
ParallelUserServerAMPs: 4
SecureServerPEs: 20
ParallelUserServerPEs: 4
TDSPLibBase: /etc/opt/teradata/tdconfig/tdsplib/
UDFLibPath:
UDFIncPath:
UDFEnvFile: /home/sally/config/udf/UDFEnvFile.txt
CLILibPath: /opt/teradata/client/14.00/lib64
CLIIncPath: /opt/teradata/client/14.00/include
CLIEnvFile: /home/sally/config/CLI/CLIEnvFile.txt
JavaLibraryPath: /etc/opt/teradata/tdconfig/jarlib/
JREPath: /opt/teradata/jvm64/jre8/jre/
JavaLogPath: /tmp/
JavaEnvFile: /home/sally/config/jvm/jvmenv.txt
JavaServerTasks: 10
JavaHybridThreads: 20
JavaVersion: 0x10004
JavaBaseDebugPort: 8000
JSVServerMemPath: /var/opt/teradata/tdtemp/jsvsrv/
MallocLimit: 33554432
GLOPLockTimeout: 130
GLOPLockWait: 120
MaximumGLOPSize: 256
MaximumGLOPMem: 2560
MaximumGLOPPages: 8
GLOPMapMemPath: /var/opt/teradata/tdtemp/udfglopdata/

Example  

This example illustrates a use of the JavaEnvFile environment file. By default, a DBS Java external stored procedure uses the tdgssconfig.jar file located in the TDBMS\bin directory when connecting to the DBS session. To have the DBS use nondefault values for the tdgssconfig.jar file, copy, modify, and place the file in the tdconfig directory on each node. Then create a JavaEnvFile to configure the JVM to use the copy of the tdgssconfig.jar file.

Note: When modifying the tdgssconfig.jar file, make a copy of it. The file may be overwritten when the DBS package is re-installed.

‑Djava.class.path=/usr/tdbms/bin/javFnc.jar;/usr/tdbms/bin/terajdbc4.jar;/usr/tdbms/bin/tdgssjava.jar;/etc/opt/teradata/tdconfig/tdgssconfig.jar;

This configures the JVM to use the standard javFnc.jar, terajdbc4.jar, and tdgssjava.jar files, but use the alternate tdgssconfig.jar file.

For more information about the Teradata JDBC driver, see Teradata JDBC Driver User Guide.

For more information about the javFnc.jar file, see SQL External Routine Programming.