Linux Shell session setup for DataStage Command Line

To setup Linux Shell for Datastage command line is very important if you are a DataStage Developer and want to work hassle free on DataStage Command Line.

Follow below steps to setup your profile ---

a) First, we will create .dshome file which is containing the path of DS Engine. If you know what it is, good, create a file in root dir with DS Engine path
otherwise execute below scripts to do it by itself

WAS Profile Creation on Linux (pctLinux.bin)

1. Change to the folder
was installation-root/bin/ProfileCreator which will be normally as follows
/opt/IBM/WebSphere/AppServer/bin/ProfileCreator
in my example /home/opt/IBM/WebSphere/AppServer/bin/ProfileCreator

2. run the command ./pctLinux.bin

3. fill the Profile Name eg. AppSrv01

How to setup environment variables in DataStage

In DataStage you can set environment variables using three different methods. The right method depends on how often you need to change the value of an environment variable and how specific this value is for a particular project or job. Here is a description of these methods:

Configuring Oracle database connectivity in a parallel environment in DataStage

Configuring access to Oracle databases includes granting the appropriate access level to users.

Granting access to the Oracle parallel server

To access the Oracle parallel server (OPS), users must have SELECT access to the sys.gv_$instance and sys.v_$cache tables.

Starting and stopping WebSphere Application Server profiles

Starting a WebSphere Application Server profile

On Windows

To start a WebSphere Application Server profile, use any of these methods:

·         Go to Start > Programs > IBM WebSphere > Application Server V7.0 > Profiles > profile_name > Start the server.

·         Start the Windows service associated with the IBM WebSphere Application Server V7.0 profile.

·         Run this command: was_install_dir\bin\startServer.bat server1 –profileName profile

·         Run this command: profile_dir\bin\startServer.bat server1

Managing profiles on WebSphere Application Server V7

Listing WebSphere Application Server profiles

To list all profiles on a server:

• On Windows: was_install_dir\bin\manageprofiles.bat –listProfiles
• On UNIX/Linux:was_install_dir/bin/manageprofiles.sh –listProfiles