Setting Up Port Number, Netrace, and Threadlogging - Teradata Tools and Utilities

Teradata Tools and Utilities for Microsoft Windows Installation Guide

Product
Teradata Tools and Utilities
Release Number
16.10
Published
April 30, 2018
Language
English (United States)
Last Update
2018-07-11
dita:mapPath
eok1488824663266.ditamap
dita:ditavalPath
windows_No_ie.ditaval.ditaval
dita:id
B035-2407
lifecycle
previous
Product Category
Teradata Tools and Utilities
Before you change the TDMSTPORT system environment variable to use a port number other than the default of 1025, contact Teradata Support to understand the ramifications.
  1. Specify the port number nnnn used by the Teradata Tools and Utilities software by setting the TDMSTPORT system environment variable as follows: set TDMSTPORT=nnnn
  2. Open the System Properties dialog box.
    Tip: To open the dialog box, open a command prompt and type SYSDM.CPL .
  3. Click the Advanced tab.
  4. Click Environment Variables and add or edit the TDMSTPORT system environment variable.
  5. Enable Detailed COPANOMLOG Logging by setting up the system environment variable NETRACE as follows: set NETRACE=1 Setting NETRACE=1 enables detailed network information between the client computer and the Teradata Database server. This information is logged in the file defined in the system environment variable COPANOMLOG.
  6. Add or edit the NETRACE system environment variable.
  7. Enable Multiple COPANOMLOG File Creation by setting up the system environment variable THREADLOGGING as follows: set THREADLOGGING=1 Threadlogging supports multi-threaded Windows applications. Multi-threaded logging is enabled by setting THREADLOGGING=1. For example, if COPANOMLOG is c:\temp\coplog and THREADLOGGING is enabled, logs are created as coplog.xxx.txt, where xxx is the thread_id in hexadecimal:
    • c:\temp\coplog.1a4.txt
    • c:\temp\coplog.db8.txt
    • c:\temp\coplog.b34.txt
    • etc.
    Each thread that uses a CLI connection creates its own individual log file.
  8. Add or edit the THREADLOGGING system environment variable.