Page 1 of 1
How to Prevent Locking Jobs
Posted: Wed May 23, 2007 3:10 am
by cosec
What are the preventive measures one could take to avoid locking his/others jobs ?
Posted: Wed May 23, 2007 5:50 am
by ray.wurlod
1. Always close clients properly.
2. Invest in hardware that means that you NEVER have network dropouts.
3. Never accidentally or deliberately disconnect the network.
Posted: Wed May 23, 2007 7:06 am
by kduke
Quit using Designer. That is the real problem.
Posted: Wed May 23, 2007 7:08 am
by chulett
Posted: Wed May 23, 2007 2:44 pm
by ray.wurlod
Forbid the use of Monitor. This also locks jobs.
Does anyone open job properties in Manager? Lock! Ban their use of the Manager client for this purpose also.
Posted: Sun May 27, 2007 6:31 pm
by asitagrawal
Hi,
Even I face the same problem, could you please tell what shoudl be done once I get this problem... ususally I restart the Datastage Services... is it the only way to unlock a job ???
Posted: Sun May 27, 2007 7:12 pm
by ray.wurlod
No. Determine the owner of the lock and its cause. Eliminate the cause.
There is also an UNLOCK command, or the DS.TOOLS menu. Search the forum for more details.
releasing locks
Posted: Sun May 27, 2007 11:44 pm
by kanchan
I think we can do this by the clean-up resources option in the director..the PID of the locked job will be shown..
Thanks,
Kanchan
Posted: Mon May 28, 2007 4:02 pm
by ray.wurlod
This is true only if the lock is owned by a non-defunct process.
