Configuring TeraData database connectivity in a parallel environment in DataStage

Installing the Teradata tools and utilities

You must install Teradata Tools and Utilities on all nodes that run parallel jobs. See the installation instructions supplied by Teradata for complete information.

Ensure that the Teradata Parallel Transporter is installed and that the following environment variables are set in the /etc/profile file:

AIX

TWB_ROOT=/usr/tbuild/08.01.00.02

PATH=$TWB_ROOT/bin:$PATH

LIBPATH=$TWB_ROOT/lib:$LIBPATH

NLSPATH=$TWB_ROOT/msg/%N

export TWB_ROOT PATH LIBPATH NLSPATH

HP-UX

TWB_ROOT=/usr/tbuild/08.01.00.02

PATH=$TWB_ROOT/bin:$PATH

SHLIB_PATH=$TWB_ROOT/lib:$SHLIB_PATH

NLSPATH=$TWB_ROOT/msg/%N

export TWB_ROOT PATH SHLIB_PATH NLSPATH

Solaris

TWB_ROOT=/usr/tbuild/08.01.00.02

PATH=$TWB_ROOT/bin:$PATH

LD_LIBRARY_PATH=$TWB_ROOT/lib:$LD_LIBRARY_PATH

NLSPATH=$TWB_ROOT/msg/%N

export TWB_ROOT PATH LD_LIBRARY_PATH NLSPATH

To run Teradata Connector jobs, add these same environment variables to the dsenv file.

Creating a Teradata user

You must create a Teradata user before you can connect from the parallel server to the Teradata database.

The Teradata database owner is the user that is referred to by a DB options property in the Teradata stage. The user must be able to create tables and insert and delete data. If you want to use a pre-existing Teradata user, install a database server and configure it to use a new database. Install the new database server with 100 MB of PERM space and 10 MB of SPOOL space.

After installing the Teradata Tools and Utilities:

Run these Basic Teradata Query (BTEQ) commands to create a user account that is stored in the terasync table.

CREATE USER user_name FROM database_name AS

PASSWORD =  user_password

PERM = 100000000

SPOOL = 10000000

After the account is set up, run the following command:

GRANT SELECT on dbc TO user_name;

njoy the simplicity.......
Atul Singh