Page 1 of 1
deleting jobs manually as they are locked in xmeta.
Posted: Wed Oct 17, 2012 12:35 pm
by peep
While deleting jobs we have this error :The Job "XXXX"cannot be found in the repository"
so before i delete the job I would like to run "cleanup_abandoned_locks.sh "
will this cause any adverse effect if i run it once in a week just as maintance ?
Posted: Wed Oct 17, 2012 2:15 pm
by ray.wurlod
No. If there are no abandoned locks it will do nothing.
Posted: Wed Oct 17, 2012 2:39 pm
by ankursaxena.2003
I don't know if this link will help you.
But, you can give a shot at it for deleting the job from Unix.
Once, my project was corrupted and I could not see the job in Designer but it was present in Director. So at that time I found the below link to delete the job manually.
http://publib.boulder.ibm.com/infocente ... layer.html
Posted: Wed Oct 17, 2012 4:40 pm
by ray.wurlod
x is a placeholder for the table name(s) returned by the IN clause. You need to study DB2 SQL a little more, it would seem.
Posted: Wed Oct 17, 2012 5:30 pm
by peep
ok sure.
thanks