db2存储过程执行表和存储过程就死锁怎么处理

SET ROWCOUNT = (SELECT COUNT(*) FROM USERID.T_SBMX_LNODE WHERE PARENT_ID = xl_ID AND SJLX_ID = 1041);

CREATE PROCEDURE USERID.PROC_SD_TOPO3
 (
  IN XL_ID BIGINT
 ) 
  LANGUAGE SQL
  NOT DETERMINISTIC
  CALLED ON NULL INPUT
  MODIFIES SQL DATA
  INHERIT SPECIAL REGISTERS
  P1: BEGIN ATOMIC
  
DECLARE TEMP_PARENT_ID BIGINT;
DECLARE TEMP_SJLX_ID BIGINT;          --临时设计设备类型ID 
DECLARE TEMP_QLNODE_ID BIGINT;        --临时支线连接的起始杆塔ID 
DECLARE TEMP_HLNODE_ID BIGINT;         --临时支线连接的终止杆塔ID 
DECLARE TEMP_QBDZ_ID BIGINT;        --临时主线连接的起始变电站ID 
DECLARE TEMP_HBDZ_ID BIGINT;           --临时主线连接的终止变电站ID 
DECLARE IS_QLNODE BIGINT;        --支线是否存在起始杆塔(0:不存在；1:存在)
DECLARE IS_HLNODE BIGINT;        --支线是否存在终止杆塔(0:不存在；1:存在)
DECLARE IS_QBDZ BIGINT;            --主线是否存在起始变电站(0:不存在；1:存在)
DECLARE IS_HBDZ BIGINT;            --主线是否存在终止变电站(0:不存在；1:存在)
DECLARE IS_Q BIGINT;             --是否存在起始设备

DECLARE TOPO_ORDER_NUM INTEGER DEFAULT 0;    --排序序号
DECLARE TOPO_FNODE_DEV_ID BIGINT;    --起始杆塔ID 
DECLARE TOPO_TNODE_DEV_ID BIGINT;    --终止杆塔ID 
DECLARE ROWCOUNT INTEGER;

--定义游标，查询线路下的所有杆塔（按运行位置编号升序）
DECLARE cur1 CURSOR FOR 
SELECT A.ID AS F_GT, 
(SELECT B.ID FROM USERID.T_SBMX_LNODE B 
 WHERE B.LNODEBH > A.LNODEBH
 AND B.PARENT_ID = 330328
 AND B.SJLX_ID = 1041
 ORDER BY B.LNODEBH ASC 
 FETCH FIRST 1 ROWS ONLY) AS T_GT
FROM USERID.T_SBMX_LNODE A
WHERE A.PARENT_ID = 330328
AND A.SJLX_ID = 1041
ORDER BY A.LNODEBH ASC
FOR FETCH ONLY;

SET ROWCOUNT = (SELECT COUNT(*) FROM USERID.T_SBMX_LNODE WHERE PARENT_ID = xl_ID AND SJLX_ID = 1041);
  
--判断输入的线路是主线还是支线
SELECT PARENT_ID, QLNODE_ID, HLNODE_ID 
INTO TEMP_PARENT_ID, TEMP_QLNODE_ID, TEMP_HLNODE_ID 
FROM USERID.T_SBMX_LNODE 
WHERE ID = xl_ID;

SELECT SJLX_ID 
INTO TEMP_SJLX_ID 
FROM USERID.T_SBMX_LNODE 
WHERE ID = TEMP_PARENT_ID;

IF (TEMP_SJLX_ID = 2447)       --输入的线路是支线时
  THEN
   SET TEMP_SJLX_ID = 0;
   SELECT SJLX_ID 
   INTO TEMP_SJLX_ID 
   FROM USERID.T_SBMX_LNODE 
   WHERE ID = TEMP_QLNODE_ID; 
   IF (TEMP_SJLX_ID = 1041)
         THEN
       SET IS_QLNODE = 1;
   END IF;
   
   SET TEMP_SJLX_ID = 0;
   SELECT SJLX_ID 
   INTO TEMP_SJLX_ID 
   FROM USERID.T_SBMX_LNODE 
   WHERE ID = TEMP_HLNODE_ID; 
   IF (TEMP_SJLX_ID = 1041)
         THEN
       SET IS_HLNODE = 1;
   END IF;                             
ELSE                         --输入的线路是主线时
 IF (TEMP_PARENT_ID <> 0)
 THEN
  --查询起始变电站ID和终止变电站ID 
  SELECT B.SCOLD1S5, B.SCOLD1S6
  INTO TEMP_QBDZ_ID, TEMP_HBDZ_ID
  FROM USERID.T_SBMX_LNODE A LEFT JOIN USERID.T_SBMX_SB_QT B ON A.SB_ID = B.ID 
  WHERE A.ID = TEMP_PARENT_ID;        
  
  SET TEMP_SJLX_ID = 0;
   SELECT SJLX_ID 
   INTO TEMP_SJLX_ID 
   FROM USERID.T_SBMX_LNODE 
   WHERE ID = TEMP_QBDZ_ID; 
   IF (TEMP_SJLX_ID = 2269)
         THEN
       SET IS_QBDZ = 1;
   END IF;    
   
   SET TEMP_SJLX_ID = 0;
   SELECT SJLX_ID 
   INTO TEMP_SJLX_ID 
   FROM USERID.T_SBMX_LNODE 
   WHERE ID = TEMP_HBDZ_ID; 
   IF (TEMP_SJLX_ID = 2269)
         THEN
       SET IS_HBDZ = 1;
   END IF;
  END IF;                                                
END IF;

IF (ROWCOUNT > 1) THEN 
DELETE FROM USER_SCDBZS.T_POWER_TOPO3 WHERE PAPERID = xl_ID;
END IF;

--处理线路下的所有杆塔
OPEN cur1;
cursorLoop1:
LOOP
FETCH cur1 INTO TOPO_FNODE_DEV_ID, TOPO_TNODE_DEV_ID;
      
SET TOPO_ORDER_NUM = TOPO_ORDER_NUM + 1;
IF (IS_QLNODE = 1)      --支线连接的起始杆塔存在时
   THEN
   SET IS_QLNODE = 0;
   INSERT INTO USER_SCDBZS.T_POWER_TOPO3(PAPERID, ORDER_NUM, LINKLINE_LOGIC_ID, FNODE_DEV_ID, TNODE_DEV_ID)
   VALUES(xl_ID, TOPO_ORDER_NUM, xl_ID, TEMP_QLNODE_ID, TOPO_FNODE_DEV_ID);  
   SET IS_Q = 1;
END IF;

IF (IS_QBDZ = 1)      --主线连接的起始变电站存在时
   THEN
   SET IS_QBDZ = 0;
   INSERT INTO USER_SCDBZS.T_POWER_TOPO3(PAPERID, ORDER_NUM, LINKLINE_LOGIC_ID, FNODE_DEV_ID, TNODE_DEV_ID)
   VALUES(xl_ID, TOPO_ORDER_NUM, xl_ID, TEMP_QBDZ_ID, TOPO_FNODE_DEV_ID);  
   SET IS_Q = 1;
END IF;

IF (IS_Q = 1)
 THEN
 SET IS_Q = 0;
 SET TOPO_ORDER_NUM = TOPO_ORDER_NUM + 1;
END IF;

IF (TOPO_FNODE_DEV_ID IS NOT NULL AND TOPO_TNODE_DEV_ID IS NOT NULL)
 THEN
--向拓扑表添加线路上的杆塔数据
INSERT INTO USER_SCDBZS.T_POWER_TOPO3(PAPERID, ORDER_NUM, LINKLINE_LOGIC_ID, FNODE_DEV_ID, TNODE_DEV_ID)
VALUES(xl_ID, TOPO_ORDER_NUM, xl_ID, TOPO_FNODE_DEV_ID, TOPO_TNODE_DEV_ID);  
END IF; 
END LOOP;
CLOSE cur1;

IF (IS_HLNODE = 1)   --支线连接的终止杆塔存在时
   THEN
   SET IS_HLNODE = 0;
   SET TOPO_ORDER_NUM = TOPO_ORDER_NUM + 1;
   INSERT INTO USER_SCDBZS.T_POWER_TOPO3(PAPERID, ORDER_NUM, LINKLINE_LOGIC_ID, FNODE_DEV_ID, TNODE_DEV_ID)
   VALUES(xl_ID, TOPO_ORDER_NUM, xl_ID, TOPO_TNODE_DEV_ID, TEMP_HLNODE_ID);  
END IF;

IF (IS_HBDZ = 1)   --主线连接的终止变电站存在时
   THEN
   SET IS_HBDZ = 0;
   SET TOPO_ORDER_NUM = TOPO_ORDER_NUM + 1;
   INSERT INTO USER_SCDBZS.T_POWER_TOPO3(PAPERID, ORDER_NUM, LINKLINE_LOGIC_ID, FNODE_DEV_ID, TNODE_DEV_ID)
   VALUES(xl_ID, TOPO_ORDER_NUM, xl_ID, TOPO_TNODE_DEV_ID, TEMP_HBDZ_ID);  
END IF;

END P1;