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

Teradata Tools and Utilities for Linux Installation Guide CentOS, Red Hat, SUSE, s390x, Ubuntu

Teradata Tools and Utilities
May 2017
To verify that the Teradata Tools and Utilities software installed properly, run the sample CLI application, clisamp. The program and its makefile are installed during installation of Teradata Tools and Utilities.

  1. Modify the following makefile so it contains the correct directory paths to the include files:
    Operating System Directory Path
    RedHat or SUSE [32-bit] makesamp.lx
    RedHat or SUSE [64-bit] makesamp.lx64
    s390x [32-bit] makesamp.390-32
    s390x [64-bit] makesamp.390
  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 or SUSE [32-bit] chmod +x clisamp
    RedHat or SUSE-[64-bit] chmod +x clisamp_lx64
    s390x [32-bit] chmod +x clisamp_390.32
    s390x [64-bit] chmod +x clisamp_390.64
  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 or SUSE [32-bit] clisamp
      RedHat or SUSE [64-bit] clisamp_lx64
      s390x [32-bit] clisamp_390.32
      s390x [64-bit] clisamp_390.64
    • Show help for the sample program:
      Operating System Command to Show Help
      RedHat or SUSE [32-bit] clisamp -h
      RedHat or SUSE [64-bit] clisamp_lx64 -h
      s390x [32-bit] clisamp_390.32 -h
      s390x [64-bit] clisamp_390.64 -h
    • Run the sample program using a user-provided input string:
      Operating System User-Provided Input String
      RedHat or SUSE [32-bit] clisamp tdpid/user,password
      RedHat or SUSE [64-bit] clisamp_lx64 tdpid/user,password
      s390x [32-bit] clisamp_390.32 tdpid/user,password
      s390x [64-bit] clisamp_390.64 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
    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 a Teradata Database, see Security Administration (B035-1100).