系统集成数据库
db2 无法drop procedure的问题
请教个问题：
在尝试调用一个procedure时，长时间运行没反应了，尝试将其drop,结果发现drop不掉，具体如下：
db2inst1@linux-db2v9:~> db2 "drop procedure abc.test_tmp"
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
尝试从“db2 select * from syscat.procedures where proname='test_tmp'”还有list applications或者db2pd -db dbname -appl或者tran和dyn中找到对应的关系，发现可以在db2pd -db dbname -dyn中找到相应的语句，但在db2pd -db dbname -appl和tran中找不到对应关系。
哪位碰到过同样的问题，知道怎么解决吗？
多谢！
在尝试调用一个procedure时，长时间运行没反应了，尝试将其drop,结果发现drop不掉，具体如下：
db2inst1@linux-db2v9:~> db2 "drop procedure abc.test_tmp"
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
尝试从“db2 select * from syscat.procedures where proname='test_tmp'”还有list applications或者db2pd -db dbname -appl或者tran和dyn中找到对应的关系，发现可以在db2pd -db dbname -dyn中找到相应的语句，但在db2pd -db dbname -appl和tran中找不到对应关系。
哪位碰到过同样的问题，知道怎么解决吗？
多谢！