zOs/SQL/DBATST

  set current sqlid = 's100447';
     drop   TABLESPACE DGDB9998.A012A;
  commit;
  CREATE TABLESPACE A012A
    IN DGDB9998
    USING STOGROUP GSMS
    PRIQTY 48 SECQTY 100
    ERASE  NO
    FREEPAGE 0 PCTFREE 10
    GBPCACHE CHANGED
    TRACKMOD YES
    SEGSIZE 8
    BUFFERPOOL BP2
    LOCKSIZE ANY
    LOCKMAX SYSTEM
    CLOSE YES
    COMPRESS YES
    CCSID      EBCDIC
    DEFINE YES
    MAXROWS 255;
--
  COMMIT;
--
------------------------------------------------------------------------
--    Table=GDB9998.TWK012A In DGDB9998.A012A
------------------------------------------------------------------------
--
  CREATE TABLE GDB9998.TWK012A
     (WK012CH20            CHAR(20) ,
      WK012CH4             CHAR(4) ,
      WK012CH2             timestamp,
      wk012tst             char(2)
     )
    IN DGDB9998.A012A
    AUDIT NONE
    DATA CAPTURE NONE
    CCSID      EBCDIC
    NOT VOLATILE;
--
  COMMIT;
--    Index=GDB9998.IWK012A0 On GDB9998.TWK012A
------------------------------------------------------------------------
--
  CREATE INDEX GDB9998.IWK012A0
    ON GDB9998.TWK012A
     (WK012CH20             ASC)
    USING STOGROUP GSMS
    PRIQTY 12 SECQTY 12
    ERASE  NO
    FREEPAGE 0 PCTFREE 10
    GBPCACHE CHANGED
    NOT CLUSTER
    BUFFERPOOL BP1
    CLOSE YES
    COPY NO
    DEFINE YES
    PIECESIZE 2 G;
--
  COMMIT;
--