stored procedure problems

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

marko@oring.si - 20 Dec 2004 15:13 GMT

Hi!

I've seen a thread a while ago about undroppable stored procedures on
LUW 7 and 8
up to 8.1.4. It's happend to me as well so I wonder if anybody has come
up with
a solution (upgrade is not feasible.) SP enters limbo if there's a
power failure
while building it.
TIA

live long and prosper

Reply to this Message

Kiran - 28 Dec 2004 07:26 GMT

I think first you should try dropping the stored procedure with correct
signature ie along with the types of each parameter.
If that does not succed try db2 terminate or even db2start; db2stop and
then try droping again. If noting is possible try deleting from
sysproc .

Kiran Nair

Reply to this Message

marko@oring.si - 28 Dec 2004 12:13 GMT

> I think first you should try dropping the stored procedure with correct
> signature ie along with the types of each parameter.
[quoted text clipped - 3 lines]
>
> Kiran Nair

Thank you, will try when I get back to work in January.

Reply to this Message