zOs/SQL/SAM15

------------------------------------------------------------------------
--                                                                    --
-- Database 2 Administration Tool (DB2 Admin) , program 5697-L90 (C)  --
--                                                                    --
-- ADB2GEN  -  Extract object definitions from the DB2 Catalog tables --
--                                                                    --
-- Input prepared on : DBOF (810)     Extract time : 2007-08-07 13:16 --
--                                                                    --
-- Catalog values overridden : none
--                                                                    --
-- Generate : SG=N DB=Y TS=Y TB=Y VW=Y IX=Y SY=N AL=N LB=Y CM=Y FK=Y  --
--            TG=N UT=N UF=N SP=N SQ=N                                --
-- Grants   : SG=N DB=Y TS=N TB=N VW=N SC=N UT=N UF=N SP=N SQ=N       --
--                                                                    --
------------------------------------------------------------------------
------------------------------------------------------------------------
--                                                                    --
-- ADB2GEN: Generate DDL for Tablespace=SAM15090 In Database DA540769 --
--                                                                    --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Database=DA540769  Stogroup=GSMS
-- Tablespace=DA540769.SAM15090
------------------------------------------------------------------------
--
  SET CURRENT SQLID='S100447';
--
  CREATE TABLESPACE SAM15090
    IN DA540769
    USING STOGROUP GSMS
    PRIQTY 90000 SECQTY 273600
    ERASE  NO
    FREEPAGE 11 PCTFREE 30
    GBPCACHE CHANGED
    TRACKMOD YES
    BUFFERPOOL BP2
    LOCKSIZE ANY
    LOCKMAX SYSTEM
    CLOSE NO
    COMPRESS YES
    CCSID      EBCDIC
    DEFINE YES
    MAXROWS 255;
--
  COMMIT;
--
------------------------------------------------------------------------
--    Table=A540769.CAURTSM In DA540769.SAM15090
------------------------------------------------------------------------
--
  SET CURRENT SQLID='A540769';
--
  CREATE TABLE A540769.CAURTSM
     ("CAURTS-ACTSTA"      CHAR(1) FOR SBCS DATA NOT NULL,
      "CAURTS-SAM-ID"      CHAR(8) FOR SBCS DATA NOT NULL,
      "CAURTSM-CLASS"      CHAR(8) FOR SBCS DATA NOT NULL,
      "CAURTSM-STAMP"      TIMESTAMP NOT NULL,
      "CAURTSM-ART-KEY"    CHAR(11) FOR SBCS DATA NOT NULL,
      "CAURTSM-MSG-ID"     CHAR(8) FOR SBCS DATA NOT NULL,
      "CAURTSM-MSG-1"      VARCHAR(78) FOR SBCS DATA NOT NULL,
      "CAURTSM-MSG-2"      VARCHAR(78) FOR SBCS DATA NOT NULL,
      "CAURTSM-MSG-3"      VARCHAR(78) FOR SBCS DATA NOT NULL,
      "CAURTSM-MSG-4"      VARCHAR(78) FOR SBCS DATA NOT NULL,
      "CAURTSM-ATTR-1"     VARCHAR(78) FOR SBCS DATA NOT NULL,
      "CAURTSM-ATTR-2"     VARCHAR(78) FOR SBCS DATA NOT NULL,
      "CAURTSM-ATTR-3"     VARCHAR(78) FOR SBCS DATA NOT NULL,
      "CAURTSM-ATTR-4"     VARCHAR(78) FOR SBCS DATA NOT NULL,
      "CAURTSM-ATTR-5"     VARCHAR(78) FOR SBCS DATA NOT NULL,
      "CAURTSM-ATTR-6"     VARCHAR(78) FOR SBCS DATA NOT NULL,
      "CAUR-CRE-STAMP"     TIMESTAMP NOT NULL,
      "CAUR-CRE-ID"        CHAR(32) FOR SBCS DATA NOT NULL,
      "CAUR-LUP-STAMP"     TIMESTAMP NOT NULL,
      "CAUR-LUP-ID"        CHAR(32) FOR SBCS DATA NOT NULL,
      CONSTRAINT "CAURTS-ACTSTA"
      PRIMARY KEY ("CAURTS-ACTSTA",
                   "CAURTS-SAM-ID",
                   "CAURTSM-CLASS",
                   "CAURTSM-STAMP",
                   "CAURTSM-ART-KEY"))
    IN DA540769.SAM15090
    AUDIT NONE
    DATA CAPTURE NONE
    CCSID      EBCDIC
    NOT VOLATILE;
--
  COMMIT;
--
------------------------------------------------------------------------
-- Database=DA540769
--    Index=A540769.IND_CAURTSM On A540769.CAURTSM
------------------------------------------------------------------------
--
  CREATE UNIQUE INDEX A540769.IND_CAURTSM
    ON A540769.CAURTSM
     ("CAURTS-ACTSTA"       ASC,
      "CAURTS-SAM-ID"       ASC,
      "CAURTSM-CLASS"       ASC,
      "CAURTSM-STAMP"       ASC,
      "CAURTSM-ART-KEY"     ASC)
    USING STOGROUP GSMS
    PRIQTY 360000 SECQTY 86400
    ERASE  NO
    FREEPAGE 11 PCTFREE 30
    GBPCACHE CHANGED
    CLUSTER
    BUFFERPOOL BP1
    CLOSE NO
    COPY NO
    DEFINE YES
    PIECESIZE 2 G;
--
  COMMIT;
--
------------------------------------------------------------------------
-- Database=DA540769
--    Index=A540769.IND_CAURTSM_D On A540769.CAURTSM
------------------------------------------------------------------------
--
  CREATE UNIQUE INDEX A540769.IND_CAURTSM_D
    ON A540769.CAURTSM
     ("CAURTS-ACTSTA"       DESC,
      "CAURTS-SAM-ID"       DESC,
      "CAURTSM-CLASS"       DESC,
      "CAURTSM-STAMP"       DESC,
      "CAURTSM-ART-KEY"     DESC)
    USING STOGROUP GSMS
    PRIQTY 360000 SECQTY 64800
    ERASE  NO
    FREEPAGE 11 PCTFREE 30
    GBPCACHE CHANGED
    NOT CLUSTER
    BUFFERPOOL BP1
    CLOSE NO
    COPY NO
    DEFINE YES
    PIECESIZE 2 G;
--
  COMMIT;
--
------------------------------------------------------------------------
-- ADB2GEN - End of generated DDL                                     --
------------------------------------------------------------------------
--