LIST.READU not showing locked jobs
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 26
- Joined: Tue Dec 18, 2007 6:31 am
LIST.READU not showing locked jobs
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?
"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?
-
- Participant
- Posts: 56
- Joined: Fri Sep 21, 2007 9:10 am
- Location: Bangalore
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
I don't know why you attempted to do anything with RT_LOGnnnn; "log" and "lock" are totally different words and concepts.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 26
- Joined: Tue Dec 18, 2007 6:31 am
-
- Participant
- Posts: 26
- Joined: Tue Dec 18, 2007 6:31 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.
-
- Participant
- Posts: 21
- Joined: Sat Sep 08, 2007 12:04 am
- Location: bangalore
Hi ,ArndW wrote:True, using that method would release all jobs open in that session. The locks should show up in the LIST.READU command. ...
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
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.