Monday, 27 January 2014

To Get a JobInfo/JobStatus/JobReport Of DataSatge Through Unix


  • To see the list of all projects present in the server:

          dsjob –lprojects


  • To see the list of jobs in a particular project:

          dsjob –ljobs project_name


  • To see the list of all the stages used in your job for a particular project:

          dsjobs –lstages project_name job_name


  • To see the list of all the links used in your job for a particular project:

          dsjobs –links project_name job_name


  • To see the list of all the paramete used in your job for a particular project:

         dsjobs –lparams project_name job_name


  • To see a basic job information of a particular project:

           dsjob -jobinfo project_name job_name


  • To see a detailed leve report of job information of a particular project:

          dsjob -report project job_name BASIC|DETAIL|XML


  • To see the list of latest 5 fatal errors from the log of the job that was just run:



         dsjob -logsum –type FATAL –max 5 project_name job_name

To Run and Stop a Job Of DataSatge Through Unix

1.To run a DataStage Job:
       dsjob –run project_name job_name

2.If you have parameters to set or paratemeterset values to set for job Then unix command will be:
 dsjob –run –param variable_name=”VALUE” –param psParameterSet=”vsValueSet” project_name  job_name

3.To stop a DataStage job:
 dsjob –stop project_name job_name

Unix Command to Restart(STOP and START) DataStage Server:

1. Log in to the engine tier computer as the IBM InfoSphere DataStage administrator (usually dsadm).
2. Change to the engine directory and set the environment.
3. cd $DSHOME
. ./dsenv
$DSHOME is the name of the engine directory. The default directory is
/opt/IBM/InformationServer/Server/DSEngine.
4. Stop the engine.
./bin/uv –admin -stop
The command displays a message when the engine stops.
5. Restart the engine.
./bin/uv –admin -start