DSXchange

Hi,
Iam having trouble with the locks. My job is getting locked if i leave it for some time. Then i need to wait for some time. Is there any way to release the job from lock.... if so can you please guide me with the steps.

developeretl wrote:Hi,
Iam having trouble with the locks. My job is getting locked if i leave it for some time. Then i need to wait for some time. Is there any way to release the job from lock.... if so can you please guide me with the steps.

Login to Datasatage Administrator
Go to Properties ->go to command
type LIST.READU
You will find the PID(inode) along with job name in tabular format.Find the job which is locked
then type
UNLOCK INODE (Inode no xxxxxx) ALL


Other Option.
Go to Director Tools then click Clear the Job Resources optionthere u note the PID Number 1.Go to Administrator 2.Properties3.Command 4.type ds.tools5. u will get options6.select 4th option6.select the 6th option7.Then enter the PID Number

In version 8 the better mechanism is to disconnect the session using Web Console for Information Server. When you open the job you get a dialog showing the owner of the lock. That's the session ID that you need to disconnect.

ray.wurlod wrote:In version 8 the better mechanism is to disconnect the session using Web Console for Information Server. When you open the job you get a dialog showing the owner of the lock. That's the session ID that you need to disconnect.

Thanks Ray !!

Some time i have seen that if your job is locked by ABC user and using Admin ID if i login to Web Console i don;t find User ID ABC's session ID in console. Well in this case You have to Unlock From Admin Command prompt or from Xmeta Database.