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

Teradata Tools and Utilities for Red Hat Enterprise Linux Installation Guide

prodname
Teradata Tools and Utilities
vrm_release
15.10.04
created_date
July 2017
category
Installation
featnum
B035-3121-077K
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:
    • makesamp.lx [32-bit]
    • makesamp.lx64 [64-bit]
    • makesamp.390-32 [32-bit]
    • makesamp.390 [64-bit]
    • makesamp.hpia32 [Integrity 32-bit]
    • makesamp.hpia64 [Integrity 64-bit]
    • makesamp.hpux [PA RISC 32-bit]
    • makesamp.hp64 [PA RISC 64-bit]
    • makesamp.aix [32-bit]
    • makesamp.aix64 [64-bit]
    • makesamp.soli386 [32-bit]
    • makesamp.solx8664 [64-bit]
    • makesamp.sol [32-bit]
    • makesamp.sol64 [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_lx64 [64-bit]
    • chmod +x clisamp_390.32 [32-bit]
    • chmod +x clisamp_390.64 [64-bit]
    • chmod +x clisamp_hpia32 [Integrity 32-bit]
    • chmod +x clisamp_hpia64 [Integrity 64-bit]
    • chmod +x clisamp [PA RISC 32-bit]
    • chmod +x clisamp_hp64 [PA RISC 64-bit]
    • chmod +x clisamp [32-bit]
    • chmod +x clisamp_aix64 [64-bit]
    • chmod +x clisamp_soli386 [32-bit]
    • chmod +x clisamp_solx8664 [64-bit]
    • chmod +x clisamp_sol [32-bit]
    • chmod +x clisamp_sol64 [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_lx64 [64-bit]
      • clisamp_390.32 [32-bit]
      • clisamp_390.64 [64-bit]
      • clisamp_hpia32 [Integrity 32-bit]
      • clisamp_hpia64 [Integrity 64-bit]
      • clisamp [PA RISC 32-bit]
      • clisamp_hp64 [PA RISC 64-bit]
      • clisamp [32-bit]
      • clisamp_aix64 [64-bit]
      • clisamp_soli386 [32-bit]
      • clisamp_solx8664 [64-bit]
      • clisamp_sol [32-bit]
      • clisamp_sol64 [64-bit]
    • Show help for the sample program:
      • clisamp -h [32-bit]
      • clisamp_lx64 -h [64-bit]
      • clisamp_390.32 -h [32-bit]
      • clisamp_390.64 -h [64-bit]
      • clisamp_hpia32 -h [Integrity 32-bit]
      • clisamp_hpia64 -h [Integrity 64-bit]
      • clisamp -h [PA RISC 32-bit]
      • clisamp_hp64 -h [PA RISC 64-bit]
      • clisamp -h [32-bit]
      • clisamp_aix64 -h [64-bit]
      • clisamp_soli386 -h [32-bit]
      • clisamp_solx8664 -h [64-bit]
      • clisamp_sol -h [32-bit]
      • clisamp_sol64 -h [64-bit]
    • Run the sample program using a user-provided input string:
      • clisamp tdpid/user,password [32-bit]
      • clisamp_lx64 tdpid/user,password [64-bit]
      • clisamp_390.32 tdpid/user,password [32-bit]
      • clisamp_390.64 tdpid/user,password [64-bit]
      • clisamp_hpia32 tdpid/user,password [Integrity 32-bit]
      • clisamp_hpia64 tdpid/user,password [Integrity 64-bit]
      • clisamp tdpid/user,password [PA RISC 32-bit]
      • clisamp_hp64 tdpid/user,password [PA RISC 64-bit]
      • clisamp tdpid/user,password [32-bit]
      • clisamp_aix64 tdpid/user,password [64-bit]
      • clisamp_soli386 tdpid/user,password [32-bit]
      • clisamp_solx8664 tdpid/user,password [64-bit]
      • clisamp_sol tdpid/user,password [32-bit]
      • clisamp_sol64 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 15.10.00.00
    MTDP version is 15.10.00.00
    MOSIOS version is 15.10.00.00
    MOSIDEP version is 15.10.00.00
    OSERR version is 15.10.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 a Teradata Database, see Security Administration, B035-1100.