Hi
I am new to IDM DB2. I am trying to create a procedure using IBM Development Center which
is available in my IBM DB2 Client. When I try to build the procedure for the first time, it
got created and when i try to rebuild the procedure after some changes in the procedure I am
getting the following error. This imapcts my development. I also checked that none of applications
are accessing the tables referred by the procedure. Any help would be appreciated.
easyinfodm.SP_PRODUCT_MIX_V2 - Build for debug started.
DROP SPECIFIC PROCEDURE easyinfodm.SQL060213064522632
easyinfodm.SP_PRODUCT_MIX_V2 - Failed to drop the stored procedure.
[IBM][CLI Driver][DB2/SUN64] SQL0911N The current transaction has been rolled back because of a deadlock or timeout. Reason code "68". SQLSTATE=40001
--Build committed--
easyinfodm.SP_PRODUCT_MIX_V2 - Build for debug completed with warnings.
Other Details
-------------
IBM DB2 Version 8.2
I am new to IDM DB2. I am trying to create a procedure using IBM Development Center which
is available in my IBM DB2 Client. When I try to build the procedure for the first time, it
got created and when i try to rebuild the procedure after some changes in the procedure I am
getting the following error. This imapcts my development. I also checked that none of applications
are accessing the tables referred by the procedure. Any help would be appreciated.
easyinfodm.SP_PRODUCT_MIX_V2 - Build for debug started.
DROP SPECIFIC PROCEDURE easyinfodm.SQL060213064522632
easyinfodm.SP_PRODUCT_MIX_V2 - Failed to drop the stored procedure.
[IBM][CLI Driver][DB2/SUN64] SQL0911N The current transaction has been rolled back because of a deadlock or timeout. Reason code "68". SQLSTATE=40001
--Build committed--
easyinfodm.SP_PRODUCT_MIX_V2 - Build for debug completed with warnings.
Other Details
-------------
IBM DB2 Version 8.2