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

Teradata Tools and Utilities for Microsoft Windows Installation Guide

Teradata Tools and Utilities
March 2014
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.