Many thanks for visiting my Blog..!!Please share this blog using below share buttons and leave your Comments/Feedback/Appreciations on Tab: Feedback
Share This Blog..!!

Delete DataStage jobs from the command line

Delete DataStage jobs From command line? 

Problem : Job becomes corrupted and unable to delete the job in Designer.

  1. 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.

  2. 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.

  3. 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"

  4. 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
5 .For detailed step by step instructions see:
 Education Assistant: Manually delete a job in IBM InfoSphere DataStage

1 comment:

disqus