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

Teradata® Tools and Utilities for Linux Installation Guide Amazon Linux 2, CentOS, OEL, RedHat, SLES, Ubuntu

prodname
Teradata Tools and Utilities
vrm_release
17.00
created_date
June 2020
category
Installation
featnum
B035-3160-220K
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 in the include files:
    Operating System Directory Path
    RedHat, SLES or OEL [32-bit] makesamp.lx
    RedHat, SLES or OEL [64-bit] makesamp.lx64
  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:
    Operating System Mode to Run
    RedHat, SLES or OEL [32-bit] chmod +x clisamp
    RedHat, SLES or OEL [64-bit] chmod +x clisamp_lx64
  4. Run the sample program using one of the following commands:
    • Run the sample program using the default logon information (dbc/systemfe,service):
      Operating System Sample Program to Run
      RedHat, SLES or OEL [32-bit] clisamp
      RedHat, SLES or OEL [64-bit] clisamp_lx64
    • Show help for the sample program:
      Operating System Command to Show Help
      RedHat, SLES or OEL [32-bit] clisamp -h
      RedHat, SLES or OEL [64-bit] clisamp_lx64 -h
    • Run the sample program using a user-provided input string:
      Operating System User-Provided Input String
      RedHat, SLES or OEL [32-bit] clisamp tdpid/user,password
      RedHat, SLES or OEL [64-bit] clisamp_lx64 tdpid/user,password
    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 17.00.00.00
    MTDP version is 17.00.00.00
    MOSIOS version is 17.00.00.00
    MOSIDEP version is 17.00.00.00
    OSERR version is 17.00.00.00
    
    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.