Cacher is the code snippet organizer for pro developers

SELECT
  AGENT_ID, LOCK_MODE, LOCK_ESCALATION, LOCK_STATUS
FROM sysibmadm.locks_held
  WHERE TABNAME IN ('T_METERING','T_METERING_CTRL')
;

SELECT
  substr(rtrim(TABSCHEMA) ||'.'|| rtrim(TABNAME),1,40) tabela,
  COUNT(*) qtde,
  timestampdiff(4,char(current timestamp - MIN(LOCK_WAIT_START_TIME))) dur_minutos
FROM sysibmadm.LOCKWAITS
GROUP BY TABSCHEMA,TABNAME
ORDER BY 2 DESC
;

SELECT
  agent_id,
  timestampdiff(4,char(current timestamp - LOCK_WAIT_START_TIME)),
  LOCK_MODE,
  LOCK_MODE_REQUESTED
FROM sysibmadm.LOCKWAITS
  where TABNAME IN ('T_METERING','T_METERING_CTRL')
ORDER BY 2 DESC
;