zOs/WK/PKGUSDDL

set current sqlid = 'S100447';
drop tablespace dA540769.aPkgUsP;
drop tablespace dA540769.aPkgUsD;
commit;
CREATE TABLESPACE aPKGUSP
    IN dA540769
    USING STOGROUP GSMS
    PRIQTY -1 SECQTY -1
    ERASE  NO
    FREEPAGE 0 PCTFREE 10
    GBPCACHE CHANGED
    TRACKMOD YES
    segsize  64
    BUFFERPOOL BP32K
    LOCKSIZE ANY
    LOCKMAX SYSTEM
    CLOSE YES
    COMPRESS YES
    CCSID unicode
    DEFINE YES
    MAXROWS 255
;
CREATE TABLE A540769.tPkgUsPdb
     (CNT                  INTEGER with default NOT NULL,
      OCCS                 FLOAT WITH DEFAULT NULL,
      SQLS                 FLOAT WITH DEFAULT NULL,
      ELA                  FLOAT WITH DEFAULT NULL,
      CPU                  FLOAT WITH DEFAULT NULL,
      TSTFR                TIMESTAMP WITH DEFAULT NULL,
      TSTTO                TIMESTAMP WITH DEFAULT NULL,
      MBRFR                CHAR(4) FOR SBCS DATA WITH DEFAULT NULL,
      MBRTO                CHAR(4) FOR SBCS DATA WITH DEFAULT NULL,
      PKG                  VARCHAR(128) FOR SBCS DATA NOT NULL,
      COL                  VARCHAR(128) FOR SBCS DATA NOT NULL)
    IN DA540769.APKGUSP
    AUDIT NONE
    DATA CAPTURE NONE
    CCSID      unicode
    NOT VOLATILE
    APPEND NO  ;
CREATE unique INDEX A540769.ipkgUsP1
  ON A540769.tPkgUsPdb
   (col
   ,pkg
   )
  USING STOGROUP GSMS
  PRIQTY -1 SECQTY -1
  ERASE  NO
  FREEPAGE 0 PCTFREE 6
  GBPCACHE CHANGED
  CLUSTER
  COMPRESS NO
  BUFFERPOOL BP1
  CLOSE YES
  COPY NO
;
set current sqlid = 'S100447';
CREATE unique INDEX A540769.ipkgUsP2
  ON A540769.tPkgUsPdb
   (pkg
   ,col
   ,tstTo
   )
  USING STOGROUP GSMS
  PRIQTY -1 SECQTY -1
  ERASE  NO
  FREEPAGE 0 PCTFREE 6
  GBPCACHE CHANGED
  not CLUSTER
  COMPRESS NO
  BUFFERPOOL BP1
  CLOSE YES
  COPY NO
;
CREATE TABLESPACE aPkgUsD
    IN dA540769
    USING STOGROUP GSMS
    PRIQTY -1 SECQTY -1
    ERASE  NO
    FREEPAGE 0 PCTFREE 10
    GBPCACHE CHANGED
    TRACKMOD YES
    segsize  64
    BUFFERPOOL BP32K
    LOCKSIZE ANY
    LOCKMAX SYSTEM
    CLOSE YES
    COMPRESS YES
    CCSID unicode
    DEFINE YES
    MAXROWS 255
;
CREATE TABLE A540769.tPkgUsd
   (LASTUSED             DATE NOT NULL
   ,Pkg               CHAR(8) FOR SBCS DATA NOT NULL
   ,contoken          CHAR(16) FOR SBCS DATA NOT NULL
   )
  IN DA540769.aPkgUsD
  AUDIT NONE
  DATA CAPTURE NONE
  CCSID      unicode
  NOT VOLATILE
  APPEND NO
;
CREATE unique INDEX A540769.iPkgUsd1
  ON A540769.tPkgUsd
   (pkg                   ASC
   ,contoken              ASC
    )
  USING STOGROUP GSMS
  PRIQTY -1 SECQTY -1
  ERASE  NO
  FREEPAGE 0 PCTFREE 6
  GBPCACHE CHANGED
  CLUSTER
  COMPRESS NO
  BUFFERPOOL BP1
  CLOSE YES
  COPY NO
  ;
commit
;