zOs/SQL/DBATST2B

  set current sqlid = 's100447';
     drop   TABLESPACE DA540769.A012B;
  -- drop   TABLE A540769b.TWK012A;
  commit;
  CREATE TABLESPACE A012B
    IN DA540769
    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=A540769b.TWK012A In DA540769.A012A
------------------------------------------------------------------------
--
  CREATE TABLE A540769b.TWK012A
     (WK012CH20            CHAR(20) ,
      WK012CH4             CHAR(4) ,
      WK012CH2             CHAR(2) ,
      wk012tst             timestamp
     )
    IN DA540769.A012B
    AUDIT NONE
    DATA CAPTURE NONE
    CCSID      EBCDIC
    NOT VOLATILE;
--
  COMMIT;
--    Index=A540769b.IWK012A0 On A540769b.TWK012A
------------------------------------------------------------------------
--
  CREATE INDEX A540769b.IWK012A0
    ON A540769b.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;
--