Unlock DataStage jobs

If a job goes to non-responsive mode and gets locked, use the following commands to unlock the jobs.

– Log into UniVerse (cmd line to DSEngine and execute bin/uvsh)
– LOGTO BI_NZCONV_DEV
– LIST DS_JOBS WITH @ID LIKE
– Make a note of the job number
– CLEAR.FILE RT_STATUS
– CLEAR.FILE RT_CONFIG
– CLEAR.FILE RT_LOG (optional)

You will then have a job in NOT COMPILED state.

Note: To run uvsh, dsenv has to be set as below
cd /opt/IBM/InformationServer/Server/DSEngine/
. ./dsenv