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

Teradata® Tools and Utilities for Oracle Solaris on SPARC and AMD Opteron Systems Installation Guide

Product
Teradata Tools and Utilities
Release Number
16.20
Published
October 2018
Language
English (United States)
Last Update
2018-10-12
dita:mapPath
csj1527114222320.ditamap
dita:ditavalPath
opteron_No_ie.ditaval.ditaval
dita:id
B035-3136
lifecycle
previous
Product Category
Teradata Tools and Utilities
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:
    • Solaris on Opteron
      • makesamp.soli386 [32-bit]
      • makesamp.solx8664 [64-bit]
    • Solaris on SPARC
      • 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:
    • Solaris on Opteron
      • chmod +x clisamp_soli386 [32-bit]
      • chmod +x clisamp_solx8664 [64-bit]
    • Solaris on SPARC
      • 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):
      • Solaris on Opteron
        • clisamp_soli386 [32-bit]
        • clisamp_solx8664 [64-bit]
      • Solaris on SPARC
        • clisamp_sol [32-bit]
        • clisamp_sol64 [64-bit]
    • Show help for the sample program:
      • Solaris on Opteron
        • clisamp_soli386 -h [32-bit]
        • clisamp_solx8664 -h [64-bit]
      • Solaris on SPARC
        • clisamp_sol -h [32-bit]
        • clisamp_sol64 -h [64-bit]
    • Run the sample program using a user-provided input string:
      • Solaris on Opteron
        • clisamp_soli386 tdpid/user,password [32-bit]
        • clisamp_solx8664 tdpid/user,password [64-bit]
      • Solaris on SPARC
        • 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 16.20.00.00
    MTDP version is 16.20.00.00
    MOSIOS version is 16.20.00.00
    MOSIDEP version is 16.20.00.00
    OSERR version is 16.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 a Teradata Database, see Teradata® Database Security Administration (B035-1100).