2020. 4. 7. 13:26
DB2
select substr(tabschema, 1, 8) || '.' || substr(tabname, 1, 16) tablename
, lock_name
, substr(lock_object_type, 1, 12) lock_object_type
, req_application_handle
, req_member
, substr(req_application_name, 1, 14) req_app_name
, hld_member
, hld_application_handle
, substr(hld_application_name, 1, 14) hld_app_name
, substr(req_stmt_text, 1, 32) req_stmt
, substr(hld_current_stmt_text, 1, 26) hel_cur_stmt
from sysibmadm.mon_lockwaits
;
req_application_handle 값으로 kill 한다.
--CALL SYSPROC.ADMIN_CMD('FORCE APPLICATION (124236)');