DSXchange

There is a DataStage job which got locked.

While trying to compile the job I am getting the error as " Cannot get access to the jobs "
We are unable to either compile or delete the jobs.
Also there being no locks in the job and DS Admin being trying to get that unlocked and still not able to do that. There being some response of getting the jobs reindexed from the DS Admin something related to INODE.

Can some one please suggest the issue what might had got messed up here and propose some solution on this.

Regards
Abhijit

Just delete all the rows in the XMETALOCKINFO table.

Has your project folks been requesting that the admin team keep killing jobs that are hung?

lstsaur wrote:Just delete all the rows in the XMETALOCKINFO table.

I am not working in DS 8.

May i know what XMETALOCKINFO table contains?

Thanks

Go to Director > Job > Cleanup Resources.

Now the new window will be ready for you.

Look into the bottom Locks and choose show all. Find your job will be waiting for you. Notedown the PID.

Then choose show all radio button in Process. There you can find the same PID.

Select it and Logout.

OR

ps -ef | grep "job name" in the unix level and kill the PID
DS User

SURA wrote:Go to Director > Job > Cleanup Resources.

Now the new window will be ready for you.

Look into the bottom Locks and choose show all. Find your job will be waiting for you. Notedown the PID.

Then choose show all radio button in Process. There you can find the same PID.

Select it and Logout.

OR

ps -ef | grep "job name" in the unix level and kill the PID
DS User

Sorry for replying late:
if you know the job yname ou can goahead with the above solution. If you are not aware of job name then grep phantom

$ ps -ef | grep phantom

it will lists processes, under that just check the pid for DSD.StageRun and kill the appropriate pid...

if you have admin rights-> you can unlock using UV Command...

Regards,
Sekhar