Page 1 of 1
LIST.READU not showing locked jobs
Posted: Wed Aug 12, 2009 2:35 am
by harish_s_ampeo
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?
Posted: Wed Aug 12, 2009 2:58 am
by yousuff1710
Through Web Console, you can disconnect the session.
Identiy the session id of the locked job & then disconnect.
Posted: Wed Aug 12, 2009 4:21 pm
by ray.wurlod
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.
Posted: Mon Sep 07, 2009 1:55 am
by harish_s_ampeo
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?
Posted: Mon Sep 07, 2009 2:01 am
by ArndW
Why not use the web console, as suggested earlier? It is simple and accurate.
Posted: Mon Sep 07, 2009 3:46 am
by harish_s_ampeo
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.
Posted: Mon Sep 07, 2009 3:52 am
by ArndW
True, using that method would release all jobs open in that session. The locks should show up in the LIST.READU command.
Posted: Tue Oct 27, 2009 7:33 am
by shiva_reddys447
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
Posted: Tue Oct 27, 2009 9:30 am
by ray.wurlod
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.