Unlocking the datastage jobs
Moderators: chulett, rschirm, roy
Unlocking the datastage jobs
Hi All,
Am facing strange issue , whenever am trying to open the job in designer window it is giving me error message job is locked by the user.
However when I tried to see the resource lock through the director client there is no resource lock.
After that I tried with the Administrator client , by executing the command LIST.READU EVERY, the output doesn't have any info about resource lock by any user.
Then I checked with the server console in session management there is no such active session.
Please help me to unlock the job.
Am facing strange issue , whenever am trying to open the job in designer window it is giving me error message job is locked by the user.
However when I tried to see the resource lock through the director client there is no resource lock.
After that I tried with the Administrator client , by executing the command LIST.READU EVERY, the output doesn't have any info about resource lock by any user.
Then I checked with the server console in session management there is no such active session.
Please help me to unlock the job.
Irfan.
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
Hi,
You have to check in XMETA database if there is any lock exists.
If there is the entry in this table,you need to delete it.
You have to check in XMETA database if there is any lock exists.
Code: Select all
SELECT * FROM XMETA.XMETALOCKINFO
Thanks
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If you have IS Administrator role, log in to the Web Console for Information Server, open the list of active sessions and disconnect the session that owns the log (the session ID is in the "locked" message). The lock will be cleared immediately.
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: 117
- Joined: Wed Feb 06, 2013 9:24 am
- Location: Chennai,TN, India
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
Hi,
I am not able to fine this script on my ETL server
I didnt get any output,can you please post the location of the script.
I am not able to fine this script on my ETL server
Code: Select all
find / -name "cleanupabondedlock.sh" -print 2>/dev/null/
Thanks
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
Ok, I think it will also delete entry from xmetalockinfo but I am not sure.let's someone focus on this.
Thanks
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Abandoned locks will be cleaned up. However, a lock held by another DataStage client is not an abandoned lock.mikva2012 wrote:what will be the impact if will run the cleanup_abandoned_locks.sh script from Unix command line.
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.
I could find a script named
cleanup_abandonded_locks.sh in my $ASBSERVER/bin directory.
cleanup_abandonded_locks.sh in my $ASBSERVER/bin directory.
Code: Select all
(/opt/IBM/InformationServer/ASBServer/bin/cleanup_abandonded_locks.sh)
You misspelled it as "abandonded" which is one reason why you couldn't find it. The other are the underscores. Probably best to search with wildcards if you're unsure of the exact name:prasson_ibm wrote:I am not able to fine this script on my ETL server
I didnt get any output,can you please post the location of the script.Code: Select all
find / -name "cleanup_abandonded_locks.sh" -print 2>/dev/null/
Code: Select all
find / -name "cleanup*.sh" -print 2>/dev/null/
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers