17.10 - Verifying the Installation Using CLI Sample Program - Teradata Tools and Utilities

Teradata® Tools and Utilities for IBM AIX Installation Guide

Teradata Tools and Utilities
Release Number
Release Date
June 2021
Content Type
Publication ID
English (United States)
Run the sample CLI application, clisamp, to verify the Teradata Tools and Utilities software installed properly.
  1. Modify the following makefile to include the correct directory paths to the include files:
    • makesamp.aix [32-bit]
    • makesamp.aix64 [64-bit]
  2. Execute the makefile:
    make -f filename

    where filename is the name of the file in the previous step.

    The executable module named clisamp is created.
  3. Change the mode of the executable to run:
    • chmod +x clisamp [32-bit]
    • chmod +x clisamp_aix64 [64-bit]
  4. Run the sample program using one of the following commands:
    • Run the sample program using the default logon information (dbc/systemfe,service):
      • clisamp [32-bit]
      • clisamp_aix64 [64-bit]
    • Show help for the sample program:
      • clisamp -h [32-bit]
      • clisamp_aix64 -h [64-bit]
    • Run the sample program using a user-provided input string:
      • clisamp tdpid/user,password [32-bit]
      • clisamp_aix64 tdpid/user,password [64-bit]
    The program logs on to the default dbccop1 (no user input supplied) specified in the /etc/hosts file, runs a simple query SELECT * from dbc.sessioninfo, and writes the output to the clisamp.dat file. A display similar to the following appears:
    CLIv2 version is
    MTDP version is
    MOSIOS version is
    MOSIDEP version is
    OSERR version is
    Logging on to --> dbc/systemfe,service
    writing out to --> CLISAMP.DAT
    submitting --> select* from dbc.sessioninfo;
    writing out to --> CLISAMP.DAT
    Logging off.
    For information about security and connecting to Vantage, see Teradata Vantage™ - Advanced SQL Engine Security Administration, B035-1100.