-- dba.v_rr_rs_ratio_aggregate - AVG and MAX of RR/RS for this time slice -- Dependency: You must first create view dba.v_rr_rs_ratio -- Downloaded from http://www.ebenner.com/db2luwdba-howto -- For use only with other components from article series: -- "Effective DB2 Monitoring with Snapshot Administrative Views" -- by Jeffrey Benner, in _DB2 LUW DBA HowTo_ -- Please direct any questions to consulting@ebenner.com -- This work is licensed under the Creative Commons Attribution 3.0 United States License. To view a copy of this license, visit http://creativecommons.org/licenses/by/3.0/us/ or send a letter to Creative Commons, 171 Second Street, Suite 300, San Francisco, California, 94105, USA. create view dba.v_rr_rs_ratio_aggregate as select SNAPSHOT_TIMESTAMP, decimal(avg(appl_rr_rs_ratio), 21, 2) as appl_rr_rs_ratio_avg, decimal(max(appl_rr_rs_ratio), 21, 2) as appl_rr_rs_ratio_max from dba.v_rr_rs_ratio group by SNAPSHOT_TIMESTAMP;