zOs/TX/WK940DDM

--
set current sqlid = 'S100447';
  CREATE TABLESPACE SDEF1T
    IN DGDB9998
    USING STOGROUP GSMSDQ0G
    PRIQTY -1 SECQTY -1
    ERASE  NO
    FREEPAGE 0 PCTFREE 5
    GBPCACHE ALL
    TRACKMOD YES
    LOGGED
    BUFFERPOOL BP2
    LOCKSIZE ANY
    LOCKMAX SYSTEM
    CLOSE YES
    COMPRESS NO
    CCSID      EBCDIC
    DEFINE YES
    MAXROWS 255;
--
  COMMIT;
--
------------------------------------------------------------------------
--    Table=GDB9998.V01_DEF In DGDB9998.SDEF1T
------------------------------------------------------------------------
--
  CREATE TABLE GDB9998.V01_DEF
     (DEF_ID               CHAR(8) FOR SBCS DATA NOT NULL,
      MU_NAME              CHAR(8) FOR SBCS DATA NOT NULL,
      MU_TYPE              CHAR(3) FOR SBCS DATA NOT NULL,
      DEF_STATUS           CHAR(11) FOR SBCS DATA WITH DEFAULT,
      SEVERITY             CHAR(8) FOR SBCS DATA WITH DEFAULT,
      PRIORITY             CHAR(8) FOR SBCS DATA WITH DEFAULT,
      DEFECTED_VER         CHAR(8) FOR SBCS DATA WITH DEFAULT,
      DETECTED_BY          CHAR(8) FOR SBCS DATA WITH DEFAULT,
      DETECTED_DT          DATE WITH DEFAULT,
      ASSIGNED_TO          CHAR(8) FOR SBCS DATA WITH DEFAULT,
      CLOSING_VER          CHAR(8) FOR SBCS DATA WITH DEFAULT,
      CLOSING_DT           DATE WITH DEFAULT,
      REPRODUCIBLE         CHAR(3) FOR SBCS DATA WITH DEFAULT,
      "SUMMARY"            VARCHAR(255) FOR SBCS DATA WITH DEFAULT,
      DESCRIPTION          VARCHAR(255) FOR SBCS DATA WITH DEFAULT,
      CONSTRAINT DEF_ID
      PRIMARY KEY (DEF_ID))
    IN DGDB9998.SDEF1T
    AUDIT NONE
    DATA CAPTURE NONE
    CCSID      EBCDIC
    NOT VOLATILE
    APPEND NO  ;
--
  COMMIT;
--
------------------------------------------------------------------------
-- Database=DGDB9998
--    Index=GDB9998.V01_I_SDEF1T_1 On GDB9998.V01_DEF
------------------------------------------------------------------------
--
  CREATE UNIQUE INDEX GDB9998.V01_I_SDEF1T_1
    ON GDB9998.V01_DEF
     (DEF_ID                ASC)
    USING STOGROUP GSMSDQ0G
    PRIQTY -1 SECQTY -1
    ERASE  NO
    FREEPAGE 0 PCTFREE 10
    GBPCACHE CHANGED
    NOT CLUSTER
    COMPRESS NO
    BUFFERPOOL BP1
    CLOSE YES
    COPY NO
    DEFER NO
    DEFINE YES
    PIECESIZE 2 G;
--
  COMMIT;
--