You can identify insert/update/delete activity at tablespace level using real-time stats (RTS) table SYSIBM.SYSTABLESPACESTATS. It's activated by default & low overhead so you probably have it available. IIRC, RTS updates every 30 minutes. See columns LASTDATACHANGE (DB2 V11) or the insert/update/delete counters for REORG% STATS% or COPY%. The columns are all updatable so you can set some to zero and periodically check for updates.
---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
