Solaris Running on a SPARC System, Solaris Running on an AMD Opteron System, HP-UX, and AIX - Parallel Transporter

Teradata Parallel Transporter Application Programming Interface

Product
Parallel Transporter
Release Number
15.00
Language
English (United States)
Last Update
2018-09-27
dita:id
B035-2516
lifecycle
previous
Product Category
Teradata Tools and Utilities

Solaris Running on a SPARC System, Solaris Running on an AMD Opteron System, HP-UX, and AIX

The following are the steps for accessing Solaris running on a SPARC system, Solaris running on an AMD Opteron system, HP-UX, and AIX:

1 After you install Teradata PT you should see the following directory structure:

\lib					(contains 32‑bit .so/.sl files)
\lib64					(contains 64‑bit .so/.sl files)
\tptapi
		\inc       (contains .h files)
		\sample
		\blockloading				(Shows how to load rows in buffer mode with the load driver)
		\checkpoint				(Shows how checkpoint/restart works with the stream driver)
		\common				(Contains shared files used by all samples)
		\generic				(Shows how each driver works)
		\getbuffer				(Shows how to export the driver’s GetBuffer feature)
		\inc				(Contains shared .h files used by all samples)
		\multiple				(Shows how to use multiple drivers in the same application)
		\multi_node				(Shows how to use the multi-node protocol)
		\threads				(Shows how to write multi-threaded applications)
	\runsamp  		(		(Contains precompiled TPTAPI applications)
 	\runsamp_aix_32(32-bit TPTAPI application built for AIX PPC)
 	\runsamp_aix_64 				  (64-bit TPTAPI application built for AIX PPC)
 	\runsamp_hpia_64		 	 (64-bit TPTAPI application built for HPUX Itanium)
 	\runsamp_hpux_32		 		 (32-bit TPTAPI application built for HPUX PARISC)
 	\runsamp_hpux_64 				 (64-bit TPTAPI application built for HPUX PARISC)
 	\runsamp_sol_o_32 (32-bit TPTAPI application built for Solaris Opteron)
 	\runsamp_sol_o_64 (64-bit TPTAPI application built for Solaris Opteron)
 	\runsamp_sol_s_32 (32-bit TPTAPI application built for Solaris Sparc)
 	\runsamp_sol_s_64 (64-bit TPTAPI application built for Solaris Sparc)

Note: The 32‑bit and 64‑bit .so/.sl files are in the Solaris, HP-UX PA RISC, and AIX packages. Only the 64‑bit .so files are in the HP‑UX IA64 package.

2 Becomes familiar with the Teradata PT methods in the sample programs (.cpp files).

3 In the sample makefile, you can see the following settings:

  • C/C++ Additional Include Directories:
  • 	../inc 				(Teradata PT common headers)
    	./inc 				(sample-only header)
    	../common 			 	(sample shared files)
  • Linker Additional Library Directories:
  • -ltelapi

    Run the makefile to build the samples.

    Note: Edit the makefile and modify the values of the C++C and CC variables to the location of the compilers on your system. Use a GNU compatible version of make when building the samples on AIX.

    Before running the makefile, verify that the directory containing the Teradata PT ICU Library (libpxicu.so/libpxicu.sl) is in the LD_LIBRARY_PATH environment variable (SHLIB_PATH for HP-UX AND LIBPATH for AIX).

    4 Set environment variables, if necessary.

    Put the sample executable, data file, and all Teradata PT .so or.sl files in the same directory. Or specify the Teradata PT directories in the PATH variables.

    Run all 32‑bit executables with 32‑bit .so or .sl files and run all 64‑bit executables with 64‑bit .so or .sl files.

    For example on Solaris running on a SPARC system and Solaris running on an AMD Opteron system:

    a export LD_LIBRARY_PATH = < library path>:$LD_LIBRARY_PATH

    export LD_LIBRARY_PATH=/opt/teradata/client/15.00/tbuild/lib:$LD_LIBRARY_PATH (32‑bit)
    export LD_LIBRARY_PATH=/opt/teradata/client/15.00/tbuild/lib64:$LD_LIBRARY_PATH (64‑bit)

    b export NLSPATH=<directory path of the catalog>/%N:$NLSPATH

    export NLSPATH=/opt/teradata/client/15.00/tbuild/msg/%N:$NLSPATH (32‑bit)
    export NLSPATH=/opt/teradata/client/15.00/tbuild/msg/%N:$NLSPATH (64‑bit)

    Note: On HP-UX, set the SHLIB_PATH and the NLSPATH environment variables.

    On AIX, set the LIBPATH and the NLSPATH environment variables.

    On an IBM AIX, when the LANG and LC_FASTMSG environment variables are set to "C" and "true", respectively, the following messages will appear after running a Teradata PT job using the tbuild command:

    Message Catalog Error: Message 4000 was not found

    Message Catalog Error: Message 2007 was not found

    Cause: Environment variable settings

    Corrective Action: Use one of the following actions to solve the error messages: change the value for the LANG environment variable to "en_US" or the value for the LC_FASTMSG environment variable to "false". Then rerun the Teradata PT job.

    Configuration Data: TPT v12 and TPT v13

    5 Set the CLIv2 environment variable THREADONOFF to 1 to run the Teradata PT multi-threaded application.

    6 Change the DBS machine name, DBS user name, and DBS user password in the BTEQ scripts setupTables.bteq and cleanupTables.bteq for each sample.

    7 Run the BTEQ script setupTables.bteq to set up the tables for the current sample.

    8 Execute the sample.

    9 Run the BTEQ script cleanupTables.bteq to clean up the tables used by the current sample.

    Note: To execute the precompiled TPTAPI applications available in \sample\runsamp directory:

  • Change your working directory to <TPTAPI install directory>\sample\runsamp
  • Run the executable that is available in this directory.
  • For example, to run a 64-bit TPTAPI application built on Solaris Sparc, issue this command at the command prompt:

    ./runsamp_sol_s_64 tdpid userid password