SELECT 
  TBSP_NAME
, TBSP_TOTAL_PAGES * TBSP_PAGE_SIZE / POWER(2, 20) TBSP_TOTAL_MB
, TBSP_USED_PAGES * TBSP_PAGE_SIZE / POWER(2, 20) TBSP_USED_MB
FROM TABLE( MON_GET_TABLESPACE (NULL, -2))

SELECT EXPLAIN_REQUESTER, EXPLAIN_TIME, SOURCE_NAME, SOURCE_SCHEMA, EXPLAIN_OPTION, SNAPSHOT_TAKEN
FROM EXPLAIN_INSTANCE
WHERE EXPLAIN_TIME >= CURRENT DATE
ORDER BY EXPLAIN_TIME DESC
-- FETCH FIRST 20 ROWS ONLY
;

SELECT 
  P.PKGNAME, P.EXPLAIN_MODE, P.EXPLAIN_SNAPSHOT
, D.ROUTINESCHEMA, D.ROUTINENAME, D.SPECIFICNAME
FROM SYSCAT.PACKAGES P
JOIN SYSCAT.ROUTINEDEP D ON D.BSCHEMA = P.PKGSCHEMA AND D.BNAME = P.PKGNAME AND D.BTYPE = 'K'
WHERE P.PKGSCHEMA = 'DB2ADMIN' AND P.PKGNAME LIKE 'P%'
AND NOT (P.EXPLAIN_MODE = 'N' AND P.EXPLAIN_SNAPSHOT = 'N')

CALL SET_ROUTINE_OPTS('EXPLAIN NO EXPLSNAP NO');