zOs/SQL/RTSINS

select current timestamp from sysibm.sysDummy1;
insert into A540769.rtsHistTs
    select r.*, current timestamp insertTst
        from sysibm.sysTableSpaceStats r
        where dbName like 'NI02%'
;
select current timestamp from sysibm.sysDummy1;
commit;
select current timestamp from sysibm.sysDummy1;
insert into A540769.rtsHistIx
    select r.*, current timestamp insertTst
        from sysibm.sysIndexSpaceStats r
        where dbName like 'NI02%'
;
select current timestamp from sysibm.sysDummy1;
commit;
select current timestamp from sysibm.sysDummy1;
;;,
select count(*)
    from sysibm.sysIndexSpaceStats
    where dbName like 'NI02%'
    ;
select count(*)
    from sysibm.sysTableSpaceStats
    where dbName like 'NI02%'
set current sqlid = 'S100447';
CREATE TABLESPACE rtsHiTs
  IN DA540769
  USING STOGROUP GSMS
  PRIQTY -1 SECQTY -1
  FREEPAGE 10 PCTFREE 5
  GBPCACHE CHANGED
  TRACKMOD YES
  LOGGED
  BUFFERPOOL BP2
  LOCKSIZE ANY
  LOCKMAX SYSTEM
  CLOSE YES
  COMPRESS YES
  CCSID      unicode
  DEFINE YES
  MAXROWS 255;
create table A540769.rtsHistTS
    as (select r.*, current timestamp insertTst
            from sysibm.sysTableSpaceStats r
       ) with no data
    in DA540769.rtsHiTs
;
CREATE        INDEX A540769.IrtsHiTs1
  ON A540769.rtsHistTS
   (dbName    asc
   ,name      asc
   ,partition asc
   ,insertTst asc
   )
  USING STOGROUP GSMS
  PRIQTY -1 SECQTY -1
  ERASE  NO
  FREEPAGE 10 PCTFREE 5
  GBPCACHE CHANGED
  CLUSTER
  COMPRESS NO
  BUFFERPOOL BP1
  CLOSE YES
  COPY NO
  DEFER NO
  DEFINE YES
  ;
CREATE TABLESPACE rtsHiIx
  IN DA540769
  USING STOGROUP GSMS
  PRIQTY -1 SECQTY -1
  FREEPAGE 10 PCTFREE 5
  GBPCACHE CHANGED
  TRACKMOD YES
  LOGGED
  BUFFERPOOL BP2
  LOCKSIZE ANY
  LOCKMAX SYSTEM
  CLOSE YES
  COMPRESS YES
  CCSID      unicode
  DEFINE YES
  MAXROWS 255;
create table A540769.rtsHistIx
    as (select r.*, current timestamp insertTst
            from sysibm.sysIndexSpaceStats r
       ) with no data
    in DA540769.rtsHiIx
;
CREATE        INDEX A540769.IrtsHiIx1
  ON A540769.rtsHistIx
   (dbName    asc
   ,indexSpace asc
   ,partition asc
   ,insertTst asc
   )
  USING STOGROUP GSMS
  PRIQTY -1 SECQTY -1
  ERASE  NO
  FREEPAGE 10 PCTFREE 5
  GBPCACHE CHANGED
  CLUSTER
  COMPRESS NO
  BUFFERPOOL BP1
  CLOSE YES
  COPY NO
  DEFER NO
  DEFINE YES
  ;
commit
;
select current timestamp from sysibm.sysDummy1;
select count(*)
    from sysibm.sysIndexSpaceStats
    where dbName like 'NI02%'
    ;
select count(*)
    from sysibm.sysTableSpaceStats
    where dbName like 'NI02%'