DROP PROCEDURE fails with SQL0911N Reason code "68". SQLSTATE=40001
Posted on 2014-01-16
I'm trying to drop a very large, complex stored procedure, which calls other stored procedures. I keep getting a lock error and if fails
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0911N The current transaction has been rolled back because of a deadlock
or timeout. Reason code "68". SQLSTATE=40001
We're running DB2 v9.7 on AIX.
Why can't I drop the procedure? We plan on recreating the procedure. Should I use "CREATE OR REPLACE PROCEDURE" instead of two discrete steps of DROP then CREATE?
Sorry, I don't deal much with stored procedures and I'm just trying to help out.