Cacher is the code snippet organizer for pro developers

select member, APPLS_IN_DB2 -1 as APPS_EXEC, APPLS_CUR_CONS - APPLS_IN_DB2 AS APPS_IDLE
		FROM TABLE(MON_GET_DATABASE(-2))
		order by 1