Stored Procedures not responding !!!!!

[balachandar]

Hi All,
We have recently created many stored procedures in our IBM DB2 UDB database. Surprisingly some of the procedures run indefifitely ,while others work just fine. Also we are not able to drop these procedures. Then also it is hanging. Has any one encountered such problems?. Please guide me on how we can solve this issue ?

Thanks and Regards
Balachandar Ganesan

 

[sathyarams]

May be they are waiting for locks ..

http://dbforums.com/t650856.html

might answer a part of your question ..

HTH

Cheers

Sathyaram More DB2 questions answered at

http://www.dbforums.com/f8