Verifying the Installation Using CLI Sample Program

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

17.00

Published

November 2020

Language

English (United States)

Last Update

2020-11-18

dita:mapPath

iba1544831946725.ditamap

dita:ditavalPath

hrk1498764225196.ditaval

dita:id

B035-3136

lifecycle

Product Category

Teradata Tools and Utilities

Run the sample CLI application, clisamp, to verify the Teradata Tools and Utilities software installed properly.

Modify the following makefile to include 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]
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.
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]
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
    
    [32-bit] clisamp_soli386
    
    [64-bit] clisamp_solx8664
  - Solaris on SPARC
    
    [32-bit] clisamp_sol
    
    [64-bit] clisamp_sol64
- Show help for the sample program:
  - Solaris on Opteron
    
    [32-bit] clisamp_soli386 -h
    
    [64-bit] clisamp_solx8664 -h
  - Solaris on SPARC
    
    [32-bit] clisamp_sol -h
    
    [64-bit] clisamp_sol64 -h
- Run the sample program using a user-provided input string:
  - Solaris on Opteron
    
    [32-bit] clisamp_soli386 tdpid/user,password
    
    [64-bit] clisamp_solx8664 tdpid/user,password
  - Solaris on SPARC
    
    [32-bit] clisamp_sol tdpid/user,password
    
    [64-bit] clisamp_sol64 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.