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 - 17.20

Deployment
VantageCloud
deployment
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Tools and Utilities
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-11-17
dita:mapPath
trg1641290463177.ditamap
dita:ditavalPath
bbv1473194095470.ditaval
dita:id
ems1473187628189
Product Category
Teradata Tools and Utilities
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.20.00.00
    MTDP version is 17.20.00.00
    MOSIOS version is 17.20.00.00
    MOSIDEP version is 17.20.00.00
    OSERR version is 17.20.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™ - Analytics Database Security Administration, B035-1100.