Question & Answer
Question
How do you generate a list of parallel DataStage jobs that use a particular parameter environment variable?
Answer
- Open the DataStage Administrator Client
- Click on the Projects tab and select the project you would like to generate a list for.
- Click the Command Button
- In the command entry box type:
LIST DS_JOBS WITH JOBTYPE = 3 AND EVAL "TRANS('DS_JOBOBJECTS','J\':@RECORD<5>:'\ROOT',14,'X')" LIKE '...<VARNAME>...'
<VARNAME> should be the name of the parameter or environment variable
Example:
LIST DS_JOBS WITH JOBTYPE = 3 AND EVAL "TRANS('DS_JOBOBJECTS','J\':@RECORD<5>:'\ROOT',14,'X')" LIKE '...TMPDIR...' - Click Execute
- If the output is on more than one page, click Next to page done and click Close when finished.
In this example, a job type of 3 is a parallel job. Valid job types value are:
0 = Server
1 = Mainframe
2 = Sequence
3 = Parallel
Note: Starting at version 8.x of DataStage the DS_JOBOBJECTS is only populated when the job is compiled via the Designer. If you were to import the job and executable or you do not have a compiler on your production system then the DS_JOBOBJECTS file would not be populated and therefore the query above will return 0 records. In order for the query above to work you need to have compiled the job using Designer, which will populate the DS_JOBOBJECTS file.
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"ARM Category":[{"code":"a8m50000000L0wHAAS","label":"DataStage->Engine Config and Management->DataStage Environment Variables"}],"ARM Case Number":"","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"All Version(s)"}]
Was this topic helpful?
Document Information
Modified date:
03 December 2020
UID
swg21618535