We suddenly started seeing archiving-related SQL statements hitting our database and causing heavy locking/contention. At the moment all archiving jobs are turned off (we disabled archiving-related Job Schedulers), but these queries keep coming and are locking our DB:
UPDATE PRPC8DATA.pr_metadata “DA” SET “PYARCHIVESTATUS” = :1 ,“PYCOMMENT” = :2 WHERE ( “DA”.“PYINSKEY” IN (:3 ) )
UPDATE PRPC8DATA.pr_metadata “DA” SET “PYARCHIVESTATUS” = :1 ,“PYCOMMENT” = :2 WHERE ( “DA”.“PYINSKEY” IN (:3 , :4 , :5 , :6 , :7 ) )
UPDATE PRPC8DATA.pr_metadata “DA” SET “PYARCHIVESTATUS” = :1 ,“PYCOMMENT” = :2 ,“PYFILELOCATION” = :3 ,“PYARCHIVEDATETIME” = SYSDATE,“PYSECONDARYSTORAGETYPE” = :4 ,“PYBATCHNAME” = :5 WHERE ( “DA”.“PYINSKEY” IN (:6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 ) )
What can we do to stop them immediately to prevent DB locks?