建立一个表,储存历史数据,比如说create table test(insert_date timestamp,tabschema varchar(30),tabname varchar(30),rows_inserted bigint,rows_updated bigint,rows_deleted bigint);2.建立一个job,每分钟把历史数据插入到test表中insert into testwith time as(SELECT...
显示全部建立一个表,储存历史数据,比如说
create table test(insert_date timestamp,tabschema varchar(30),tabname varchar(30),rows_inserted bigint,rows_updated bigint,rows_deleted bigint);
2.建立一个job,每分钟把历史数据插入到test表中
insert into test
with time as(SELECT
current_timestamp cu_time from sysibm.dual)
select
cu_time ,
varchar(tabschema,20) as tabschema,
varchar(tabname,20) as tabname,
rows_inserted,
rows_updated,
rows_deleted
FROM TABLE(MON_GET_TABLE('','',-2)) AS t ,time
3.想统计1分钟,5分钟,1个小时,1天,因为表test里已有时间
所以,你只要 选择你的时间间隔,就可以计算出各种你要的结果
收起