Unanswered: dropping a stored procedure created by the Put Routine function
I have defined a stored procedure on a host, without a C compiler, using the Put Routine function. I used drop procedure to remove it. However whenever I go to recreate the procedure using Put Routine, I get the following error :
SQL0443N Routine "PUT_ROUTINE_SAR" (specific name "db2udp!put_routine_sar")
has returned an error SQLSTATE with diagnostic text "-658, 42917, P2241370".
Why does this happen? How do I drop the procedure so I can recreate it using Put Routine?
Hope you are using the same command (put_routine) which you have used for the first time.
Usually you have to specify the owner in the put_routine command and the owner should have necessary privileges.
Probably you can check in the syscat.procedures to see if the procedure got dropped from this view also.