LIST.READU not showing locked jobs

harish_s_ampeo · Post by **harish_s_ampeo** » Wed Aug 12, 2009 2:35 am

The Locked job is not getting listed when i execute LIST.READU from administrator or datastage prompt.It is not showing up under
"clean up resources" in director also.Tried clearing RTLOG file of the locked job,but its not releasing the lock.Is there any other way to get it unlocked?

yousuff1710 · Post by **yousuff1710** » Wed Aug 12, 2009 2:58 am

Through Web Console, you can disconnect the session.
Identiy the session id of the locked job & then disconnect.

ray.wurlod · Post by **ray.wurlod** » Wed Aug 12, 2009 4:21 pm

The lock, then, is in the unified metadata repository (XMETA), not the local DataStage project repository. Locks in this repository are stored in a table called XMETALOCKINFO. As noted, however, the appropriate way to clear the lock is to use the session ID reported in the "job locked" message and disconnect that session using the Web Console for Infomation Server.

I don't know why you attempted to do anything with RT_LOGnnnn; "log" and "lock" are totally different words and concepts.

harish_s_ampeo · Post by **harish_s_ampeo** » Mon Sep 07, 2009 1:55 am

When I checked XMETALOCKINFO table , I find that -If a user has opened 3 jobs in a session there are 3 rows against that user id,session_id with unique values for "Repository_ID" and "Locked_At" . If I want to release one particular job,How to find which row points to which job?

ArndW · Post by **ArndW** » Mon Sep 07, 2009 2:01 am

Why not use the web console, as suggested earlier? It is simple and accurate.

harish_s_ampeo · Post by **harish_s_ampeo** » Mon Sep 07, 2009 3:46 am

Is it not like, when I disconnect a session from webconsole all jobs assosciated with that session will get released?For eg,I have 2 jobs open in a session, I have made changes to both the jobs but not saved.When I give view data on one job,its struck over there.In this case I would like to kill that particulr job alone,wouldn't wish to redo both the jobs.

ArndW · Post by **ArndW** » Mon Sep 07, 2009 3:52 am

True, using that method would release all jobs open in that session. The locks should show up in the LIST.READU command.

shiva_reddys447 · Post by **shiva_reddys447** » Tue Oct 27, 2009 7:33 am

ArndW wrote:True, using that method would release all jobs open in that session. The locks should show up in the LIST.READU command. ...

Hi ,

May i know the procedure to connect to XMETALOCKINFO table

because earlier i was connecting to UV databse by executing uvsh or dssh.

And i understood that it requires to connect XMETA to get access to table

XMETALOCKINFO

ray.wurlod · Post by **ray.wurlod** » Tue Oct 27, 2009 9:30 am

What database do you use for the XMETA database? Use a regular client for that particular database. Note that affecting XMETALOCKINFO directly is neither supported nor recommended by the vendor. You should use the Web Console wherever possible.