SEO

#1 (**permalink**) 02-27-2008, 02:30 AM

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

#2 (**permalink**) 02-27-2008, 02:32 AM

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

#3 (**permalink**) 02-27-2008, 02:32 AM

Kiran wrote:
> 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

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

stored procedure problems