SELECT 
  EVENT_MON_STATE(M.EVMONNAME) STATE 
, VARCHAR(M.EVMONNAME, 20) EVMONNAME
, VARCHAR(E.TYPE, 20) TYPE
, M.TARGET_TYPE
, VARCHAR(T.LOGICAL_GROUP, 20) LOGICAL_GROUP
, VARCHAR(
  CASE 
    WHEN M.TARGET_TYPE IN ('F', 'P') THEN M.TARGET 
    ELSE RTRIM(T.TABSCHEMA||'.'||T.TABNAME) 
  END
  , 50) TARGET
FROM SYSCAT.EVENTMONITORS M
JOIN SYSCAT.EVENTS E ON E.EVMONNAME=M.EVMONNAME
LEFT JOIN SYSCAT.EVENTTABLES T ON T.EVMONNAME=M.EVMONNAME
ORDER BY M.EVMONNAME;

with c (colname) as (values 
  'STMT_TEXT'
, 'STMT_TYPE'
, 'SECTION_NUMBER'
, 'PACKAGE_NAME'
, 'PACKAGE_VERSION_ID'
, 'APPL_ID'
)
select s.tabschema, s.tabname
from syscat.columns s 
join c on c.colname=s.colname
where s.tabschema not like 'SYS%'
group by s.tabschema, s.tabname
having count(1)=(select count(1) from c)