zOs/SQL/CREDUMMY

  SET CURRENT SQLID='S100447';
  -- drop database db2dummy;
  commit;
  CREATE DATABASE DB2DUMMY
    BUFFERPOOL BP2
    INDEXBP    BP1
    CCSID      EBCDIC
    STOGROUP   GSMS;
  CREATE TABLESPACE DUMMY
    IN DB2DUMMY
    USING STOGROUP GSMS
    PRIQTY -1 SECQTY -1
    FREEPAGE 0 PCTFREE 10
    GBPCACHE CHANGED
    TRACKMOD YES
    SEGSIZE 64
    BUFFERPOOL BP2
    LOCKSIZE ANY
    LOCKMAX SYSTEM
    CLOSE YES
    COMPRESS YES
    CCSID      EBCDIC
    DEFINE YES
    MAXROWS 255;
--
  COMMIT;
--
------------------------------------------------------------------------
--    Table=A540769.TWK001A In DA540769.A001A
------------------------------------------------------------------------
--

  CREATE TABLE DUMMY.DUMMY2
     (DUMMY                CHAR(1)
     )
    IN DB2DUMMY.DUMMY
    AUDIT NONE
    DATA CAPTURE NONE
    CCSID      EBCDIC
    NOT VOLATILE;
  LABEL ON TABLE DUMMY.DUMMY2 IS 'dummy table - nicht droppen||';
  CREATE UNIQUE INDEX DUMMY.DUMMY2
    ON DUMMY.DUMMY2
     (DUMMY                 ASC)
    USING STOGROUP GSMS
    PRIQTY -1 SECQTY -1
    ERASE  NO
    FREEPAGE 0 PCTFREE 10
    GBPCACHE CHANGED
    NOT CLUSTER
    BUFFERPOOL BP1
    CLOSE YES
    COPY NO
    DEFINE YES
    PIECESIZE 2 G;
  COMMIT;