Delete DataStage jobs From command line?
- Login to the DataStage Administrator.
Select the Project and click the Command button. Then execute the following command:
LIST DS_JOBS <job_name>
Note the job number, which is the third line listed as No.... In the example above the job number is 51.
- Go to the project directory and list all files with the job number returned from item 1.
On Unix/Linux execute, "ls | grep <job_number>". On Windows use search in Windows Explorer or from command (DOS) prompt use "dir *<job number>". This should output something like:
DS_TEMPxx,
RT_BPxx,
RT_BPxx.O,
RT_CONFIGxx,
RT_LOGxx,
RT_STATUSxx,
RT_SCxx
where xx is the job number.
- Delete all the files found in step 2.
On Unix/Linux
"rm -r <FileName>xx", e.g. "rm -r DS_TEMP51".
On Windows
Delete these from Windows Explorer or from command (DOS) prompt execute:
"del <FileName>nn", e.g. "del DS_TEMP51"
- In DataStage Administrator command window execute the commands below one by one:
DELETE VOC DS_TEMPxx
DELETE VOC RT_BPxx
DELETE VOC RT_BPxx.O
DELETE VOC RT_CONFIGxx
DELETE VOC RT_LOGxx
DELETE VOC RT_STATUSxx
DELETE VOC RT_SCxx
DELETE DS_JOBS job_name
Education Assistant: Manually delete a job in IBM InfoSphere DataStage
Thanks for reading my blogs..!
ReplyDelete