DB2 upsert 로직 예시 WITH upsert AS ( UPDATE taxagent_schema.ftx_apply_wehago SET smarta_company_name = #{smarta_company_name} , server_keylock = #{server_keylock} , client_keylock = #{client_keylock} , taxagent_biz_no = #{taxagent_biz_no} , suimcheo_biz_no = #{suimcheo_biz_no} , random_key = #{random_key} , session_id = #{session_id}::varchar , apply_route = '1' , session_timestamp = now() WHERE server_keylock = #{.. 2021. 10. 2. DB Lock 조회 및 PID 중지 -- 실행중인 쿼리 runtime 추가 SELECT datid, pid, current_timestamp - query_start AS runtime, datname, usename, query FROM pg_stat_activity WHERE state = 'active' --AND current_timestamp - query_start > '1 min' ORDER BY 3 DESC; -- 1)실행중인 전체 쿼리 확인 SELECT pid, query, * FROM pg_stat_activity where state = 'active' ORDER BY query_start ASC; -- 2) 현재 테이블에 Lock을 확인하는 쿼리 -- RowExclusiveLock같은것이 검색되면 다른 쿼리에도 영향을.. 2021. 10. 2. 이전 1 다음