17.00 - 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
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-11-20
dita:mapPath
ofn1544831946734.ditamap
dita:ditavalPath
dpj1465132351025.ditaval
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:
    set TDMSTPORT=nnnn
  2. Open the System Properties dialog box.
    Tip: 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:

    set NETRACE=1

    Setting NETRACE=1 enables detailed network information between the client computer and Vantage. 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:

    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.