How to Prevent Locking Jobs

cosec · Post by **cosec** » Wed May 23, 2007 3:10 am

What are the preventive measures one could take to avoid locking his/others jobs ?

ray.wurlod · Post by **ray.wurlod** » Wed May 23, 2007 5:50 am

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.

kduke · Post by **kduke** » Wed May 23, 2007 7:06 am

Quit using Designer. That is the real problem.

chulett · Post by **chulett** » Wed May 23, 2007 7:08 am

ray.wurlod · Post by **ray.wurlod** » Wed May 23, 2007 2:44 pm

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.

asitagrawal · Post by **asitagrawal** » Sun May 27, 2007 6:31 pm

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 ???

ray.wurlod · Post by **ray.wurlod** » Sun May 27, 2007 7:12 pm

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.

kanchan · Post by **kanchan** » Sun May 27, 2007 11:44 pm

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

ray.wurlod · Post by **ray.wurlod** » Mon May 28, 2007 4:02 pm

This is true only if the lock is owned by a non-defunct process.

DSXchange

How to Prevent Locking Jobs

How to Prevent Locking Jobs

releasing locks