15.00 - Chapter 28 Teradata Network Tuner (tdntune) - 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

WARNING:

Setting tunable parameters improperly can degrade system performance. This utility should only be used under the direction of the Teradata Support Center.

The Teradata Network Tuner utility, tdntune, reads, displays, and writes Teradata Database Network Services tunable parameters. TDN is a PDE subsystem that provides Teradata Database Network Services.

Tunables are stored in the PDE Control GDO, a Teradata Database globally distributed object that stores settings which are automatically made available to all nodes in the system.

Scenarios Runs From

  • Database Window or comparable interface to the Teradata Database console subsystem, such as cnsterm
  • Linux command line
  • For general information on starting the utilities from different interfaces, see Appendix B: “Starting the Utilities”

    Scenarios Syntax

     

    Syntax element

    Description

     

    -h

    Displays the help for tdntune.

     

    get [file]

    Displays or writes the current settings of Teradata Database network services tunable parameters from the PDE Control GDO.

    Optionally, you can specify a file name, and the settings will be written to a text file.

  • To change the Teradata Database network services tunable parameter settings, edit this file and run tdntune using the set option, and specifying the file name.
  • If a file name is not specified, the settings are displayed on screen; this is the default behavior of tdntune.
  •  

    set file

    Reads new settings for Teradata Database network services tunable parameters from file, and writes them to the PDE Control GDO, making those settings available to all nodes of the system. file is required with the set option.

     

    Example  

    To show TDN tunables, type the following at the command line:

    tdntune

    Depending on your system, output similar to the following appears:

    # Fri Jan 30 08:27:24 2004

    # GDO TDN TUNEABLES:
    # ------------------
    PAGE_LWM                  128
    PAGE_HWM                 1500
    PAGE_REQ                   64
    PAGE_REL                  128
    PAGE_MAX_REQS               4
    PAGE_LMHR                1000
    CHN_BLK_TICK                1
    GRP_BLK_TICK                1
    GSM_BLK_TICK                1
    MRG_BLK_TICK                4
    MSG_BLK_TICK                4
    FC_P2PREC_BLK_TICK          4
    FC_P2PSEG_BLK_TICK          4
    FC_GRPREC_BLK_TICK          4
    FC_GRPSEG_BLK_TICK          4
    SVC_TIME_METHOD          UNIX_TIME
    GWS_DISABLE                 0
    FCIN_P2PCHN_THRESHLD        5
    FCIN_P2PCHN_INITVAL       255
    FCIN_P2PGRP_THRESHLD        5
    FCIN_P2PGRP_INITVAL        20
    FCIN_GRP_THRESHLD           5
    FCIN_GRP_INITVAL           20
    FCIN_CHN_THRESHLD           5
    FCIN_CHN_INITVAL           20
    FCIN_RFC_ENABLE             1
    FCIN_RFC_THRESHLD          20
    FCOUT_THRESHLD              5
    FCOUT_INITVAL               5

    # GDO FCIN_ADJ (Read-only) fields:
    # --------------------------------
    # TPA_NODE_COUNT             2
    # FCIN_P2PCHN_ADJ_INITVAL  235
    # FCIN_P2PGRP_ADJ_INITVAL    0
    # FCIN_GRP_ADJ_INITVAL       0
    # FCIN_CHN_ADJ_INITVAL       0