DSXchange

I got it. I deleted all the rows from XMETALOCKINFO table. Now all the job locks got released.

Thanks a lot, lstsaur.

Please let me where can I find this XMETALOCKINFO table.

I killed the process by PID and stopped and restarted the server. Still the job locks are not released. Please advise.

Hi,, When I used the below command , I got the below output au02uap003btox2:/opt/IBM/InformationServer/Server/DSEngine$ps -ef| grep dsadm dsadm 389222 794780 0 08:49:31 - 0:00 sshd: dsadm@pts/0 dsadm 458898 569458 0 08:59:08 - 0:00 dsapi_slave 7 6 0 dsadm 569458 1044508 0 08:59:08 - 0:00 dscs 4 0 0 ...

Hi,, When I used the below command , I got the below output au02uap003btox2:/opt/IBM/InformationServer/Server/DSEngine$ps -ef| grep dsadm dsadm 389222 794780 0 08:49:31 - 0:00 sshd: dsadm@pts/0 dsadm 458898 569458 0 08:59:08 - 0:00 dsapi_slave 7 6 0 dsadm 569458 1044508 0 08:59:08 - 0:00 dscs 4 0 0 ...

I stopped and re-started the server, but the jobs are still getting locked

Hi,

I have changed the start=0 to start=1 in dsdlocked.config file in $dshome directory. still the job is getting locked. Please advise

Hi Ray,

As posted in the forum, I went and checked in the session Management --> Active sessions in IBM information server console, session ID I got while opening the job is not present. Is there any other way to unlock the jobs, Please advise.

I am unable to open certain jobs in Datastage server edition 8. I stopped and started the server and also tried to clean up the resources for unlocking the jobs in Director. Can anyone guide me thru the steps to be followed. I am getting this below error 'Unable to open the job The job 'ADDRESS_HAS...

I am unable to open certain jobs in Datastage server edition 8. I stopped and started the server and also tried to clean up the resources for unlocking the jobs in Director. Can anyone guide me thru the steps to be followed. I am getting this below error 'Unable to open the job The job 'ADDRESS_HASH...