Unable to access the existing job

[puli.reddy]

When I tried to open the job it gives error as follows..

"Job is being accessed by another user"

I tried to clean up the job resource in datastage director, but I didn't succed to cleanup the resource. It gives error as follows..

ERROR: Cannot find any process numbers for stages in job PopulateDTKTDFareBasis.

Could anyone advice on this please!

[richdhan]

Hi,

Do list_readu

$DSHOME/bin/list_readu

This will show the list of open jobs and who is working on that.

If you want to release the lock on the job do this

1) Login in into the Datastage server box from the command line as datastage adminstrator
2) goto Home directory i.e DSEngine directory
3) enter . ./dsenv
4) enter bin/uv or enter bin/dssh
5) LOGTO Project [project is your project name]
6) LIST.READU EVERY
7) Under ACTIVE Recors Locks, you have a Item_ID column, where you can find the job you want to unlock
8.) get the node number [column 2] and the user number [column 4] for the locked job you have identified
9) enter LOGTO UV
10) DS.UNLOCK NODE nodenumber USER usernumber ALL
11) Press Q to quit from Command mode to Unix mode

HTH
--Rich

[kumar_s]

Click on ok, and under locks, select Show All.
You might find your job. Note down the PID. Select the PId from Process block.
Now again click on show by process under Locks.
Click on release All.
Try to use dsadm user id.