zOs/SQL/TECSVDDO

       -- ddl tecSv: unload DSNs fuer ControlSummary
       --
set current sqlid = 'S100447';
-- alter  TABLE OA1P.tqz005tecSvUnload drop restrict on drop;
drop   tablespace QZ01A1P.A004A ;
drop   tablespace QZ01A1P.A005A ;
commit;
CREATE TABLESPACE a005a
    IN QZ01A1P
    USING STOGROUP GSMS
    PRIQTY -1 SECQTY -1
    ERASE  NO
    FREEPAGE 0 PCTFREE 5
    GBPCACHE CHANGED
    TRACKMOD YES
    SEGSIZE 64
    BUFFERPOOL BP2
    LOCKSIZE ANY
    LOCKMAX SYSTEM
    CLOSE YES
    COMPRESS YES
    CCSID      unicode
    DEFINE YES
    MAXROWS 255;
;
CREATE TABLESPACE a004a
    IN QZ01A1P
    USING STOGROUP GSMS
    PRIQTY -1 SECQTY -1
    ERASE  NO
    FREEPAGE 0 PCTFREE 5
    GBPCACHE CHANGED
    TRACKMOD YES
    SEGSIZE 64
    BUFFERPOOL BP2
    LOCKSIZE ANY
    LOCKMAX SYSTEM
    CLOSE YES
    COMPRESS YES
    CCSID      unicode
    DEFINE YES
    MAXROWS 255;
;
CREATE TABLE OA1P.tqz004tecSvLgRn
  ( db        char(8)  not null
  , ts        char(8)  not null
  , pa        smallint not null
  , start     timestamp not null
  , sLrsn     timestamp not null
  , cnt       int not null
  )
  in qz01a1p.a004a
    AUDIT NONE
    DATA CAPTURE changes
    CCSID      unicode
    WITH RESTRICT ON DROP
    NOT VOLATILE;

CREATE UNIQUE INDEX oa1p.iQZ004a1
  ON oa1p.tqz004TecSvLgRn
   (db, ts, pa)
   include(start)
  USING STOGROUP GSMS
  ERASE  NO
  GBPCACHE CHANGED
  CLUSTER
  BUFFERPOOL BP1
  CLOSE YES
  COPY NO
  DEFINE YES
;
CREATE TABLE OA1P.tqz005tecSvUnload
  ( db        char(8)  not null
  , ts        char(8)  not null
  , pa        smallint not null
  , stage     char(2)  not null
  , staUpd    timestamp not null
  , staTb     char(2) not null
  , unlTst    timestamp not null
  , unl       char(44) not null
  , punTst    timestamp not null
  , pun       char(44) not null
  , info      varchar(70) not null
  , err       varchar(70) not null
  )
  in qz01a1p.a005a
    AUDIT NONE
    DATA CAPTURE changes
    CCSID      unicode
    WITH RESTRICT ON DROP
    NOT VOLATILE;

CREATE UNIQUE INDEX oa1p.iQZ005a1
  ON oa1p.tqz005TecSvUnload
   (db, ts, pa)
   include(stage)
  USING STOGROUP GSMS
  ERASE  NO
  GBPCACHE CHANGED
  CLUSTER
  BUFFERPOOL BP1
  CLOSE YES
  COPY NO
  DEFINE YES
;
commit