configuring DB2 database connectivity in a parallel environment in DataStage

Configure DataStage to run on all processing nodes that function as DB2 servers.

Steps

To configure InfoSphere DataStage to access IBM DB2 servers, include a node definition for each IBM DB2 server node in the configuration file. Also, complete the following steps.

Running the IBM DB2 configuration script
Use the DB2 configuration script to configure access to IBM DB2 databases.

Procedure
From the Linux or UNIX command line, run the $APT_ORCHHOME/bin/db2setup.sh script once for each IBM DB2 database that users will access. Pass the database name as an argument.

For example, the following command calls db2setup.sh to configure access to the database db2db:

db2setup.sh db2db


Granting user privileges to run IBM DB2 Enterprise stage jobs
You must grant privileges to each user who runs jobs that contain the DB2 Enterprise stage.

Procedure
Run the $APT_ORCHHOME/bin/db2grant.sh script once for each user. Use the following syntax:

db2grant.sh database_name user_name

Accessing a remote IBM DB2 server from IBM DB2 Enterprise stages
You use an DB2 client to connect from an IBM DB2 Enterprise stage to a remote IBM DB2 server.

Thanks - http://datastage4you.blogspot.in/2012/08/configuring-db2-database-connectivity.html#.Uuf9QhC6bIU