-- dba.v_table_rows_written_perminute - Per Table, Rows Written per minute -- 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. drop view dba.v_table_rows_written_perminute; create view dba.v_table_rows_written_perminute as select snap0.SNAPSHOT_TIMESTAMP, snap0.tabschema, snap0.tabname, ( decimal(decimal(( snap0.ROWS_WRITTEN - ( select snap1.ROWS_WRITTEN from dba.snaptab as SNAP1 where snap1.tabschema = snap0.tabschema and snap1.tabname = snap0.tabname and snap1.SNAPSHOT_TIMESTAMP = ( select max(snap2.SNAPSHOT_TIMESTAMP) from dba.snaptab as SNAP2 where snap2.SNAPSHOT_TIMESTAMP < snap0.SNAPSHOT_TIMESTAMP and snap2.tabschema = snap0.tabschema and snap2.tabname = snap0.tabname ) ) ), 21, 2) / decimal(timestampdiff(4, char( snap0.SNAPSHOT_TIMESTAMP - ( select max(snap2.SNAPSHOT_TIMESTAMP) from dba.snaptab as SNAP2 where snap2.SNAPSHOT_TIMESTAMP < snap0.SNAPSHOT_TIMESTAMP and snap2.tabschema = snap0.tabschema and snap2.tabname = snap0.tabname )) ), 21, 2), 21, 2) ) as TABLE_ROWS_WRITTEN_PER_MINUTE from dba.snaptab as SNAP0 ;