Review the top consumers of SQL resources since the last IPL.

SQL Environmental Limits

-- Resource: 
-- https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_74/rzajq/rzajqhealthenvlimits.htm
--

DECLARE GLOBAL TEMPORARY TABLE Health_Environmental_Limits
     LIKE QSYS2.QSQHENVLIM
     WITH REPLACE
     NOT LOGGED ON ROLLBACK PRESERVE ROWS
     ON COMMIT PRESERVE ROWS;

INSERT INTO SESSION.Health_Environmental_Limits 
	   SELECT A.COLLECTED_TIME, B.COMMENTS, A.HIGHWATER_MARK, 
           A.WHEN_RECORDED, A.PERCENT, 
           A.JOB_NAME, A.CURRENT_USER,  
           A.JOB_TYPE, B.SUPPORTED_VALUE, 
           A.JOB_STATUS, 
           A.CLIENT_WRKSTNNAME, 
           A.CLIENT_APPLNAME, A.CLIENT_ACCTNG, 
           A.CLIENT_PROGRAMID, A.CLIENT_USERID,          
           A.LIMITS_ESTABLISHED, A.INTERFACE_NAME, 
           A.INTERFACE_TYPE, A.INTERFACE_LEVEL, 
           A.LIMIT_ID
	   FROM 
	   TABLE(QSYS2.ENVIRONMENTAL_LIMITS ( )) AS A, 
	   QSYS2.SQL_SIZING AS B 
	   WHERE A.LIMIT_ID = B.SIZING_ID;

select * from SESSION.Health_Environmental_Limits;