zOs/WK/OPTHIDDL

SET CURRENT SQLID = 'S100447';
    xROP   TABLESPACE QZ01A1P.A080A;
    xROP   TABLESPACE QZ01A1P.A080X;
    xROP   TABLESPACE QZ01A1P.A081A;
    COMMIT;
    CREATE TABLESPACE A080A
           IN QZ01A1P
           USING STOGROUP GSMS
               PRIQTY -1
               SECQTY -1
               ERASE NO
           BUFFERPOOL BP2
           CLOSE YES
           LOCKMAX SYSTEM
           SEGSIZE 64
           GBPCACHE CHANGED
           DEFINE YES
           LOGGED
           TRACKMOD YES
           COMPRESS YES
           LOCKSIZE PAGE
           MAXROWS 255
           CCSID UNICODE;
    CREATE LOB TABLESPACE A080X
           IN QZ01A1P
           USING STOGROUP GSMS
               PRIQTY -1
               SECQTY -1
               ERASE NO
           BUFFERPOOL BP32K
           DSSIZE 4G
           CLOSE YES
           LOCKMAX SYSTEM
           GBPCACHE CHANGED
           DEFINE YES
           LOGGED
           LOCKSIZE ANY;

    CREATE TABLESPACE A081A
           IN QZ01A1P
           USING STOGROUP GSMS
               PRIQTY -1
               SECQTY -1
               ERASE NO
           BUFFERPOOL BP2
           CLOSE YES
           LOCKMAX SYSTEM
           SEGSIZE 64
           GBPCACHE CHANGED
           DEFINE YES
           LOGGED
           TRACKMOD YES
           COMPRESS YES
           LOCKSIZE PAGE
           MAXROWS 255
           CCSID UNICODE;


    CREATE TABLE OA1P.TQZ080OptHintQuery
        (EXPLAIN_TIME TIMESTAMP NOT NULL WITH DEFAULT
        , DESC     CHAR(80)                            NOT NULL
        ,"QUERYNO" INTEGER
                                          NOT NULL WITH DEFAULT
        ,"SCHEMA" VARCHAR(128) FOR MIXED DATA
                                                        NOT NULL
  WITH DEFAULT ' '
        ,HINT_SCOPE SMALLINT
                                                        NOT NULL
  WITH DEFAULT 0
        ,QUERY_TEXT CLOB(2M) FOR MIXED DATA             NOT NULL
           --  INLINE LENGTH 10   WITH DEFAULT ''
        ,QUERY_ROWID ROWID
                                                        NOT NULL
  GENERATED ALWAYS
        ,QUERYID BIGINT
                                                        NOT NULL
  WITH DEFAULT 0
        ,USERFILTER CHARACTER(8) FOR MIXED DATA
                                                        NOT NULL
  WITH DEFAULT ' '
        ,OTHER_OPTIONS CHARACTER(128) FOR MIXED DATA
                                                        NOT NULL
  WITH DEFAULT ' '
        ,"COLLECTION" VARCHAR(128) FOR MIXED DATA
                                                        NOT NULL
  WITH DEFAULT ' '
        ,"PACKAGE" VARCHAR(128) FOR MIXED DATA
                                                        NOT NULL
  WITH DEFAULT ' '
        ,VERSION VARCHAR(128) FOR MIXED DATA
                                                        NOT NULL
  WITH DEFAULT ' '
        ,REOPT CHARACTER(1) FOR MIXED DATA
                                                        NOT NULL
  WITH DEFAULT ' '
        ,STARJOIN CHARACTER(1) FOR MIXED DATA
                                                        NOT NULL
  WITH DEFAULT ' '
        ,MAX_PAR_DEGREE INTEGER
                                                        NOT NULL
  WITH DEFAULT -1
        ,DEF_CURR_DEGREE CHARACTER(3) FOR MIXED DATA
                                                        NOT NULL
  WITH DEFAULT ' '
        ,SJTABLES INTEGER
                                                        NOT NULL
  WITH DEFAULT -1
        ,OTHER_PARMS VARCHAR(128) FOR MIXED DATA
                                                        NOT NULL
  WITH DEFAULT ' '
        )
        IN QZ01A1P.A080A
   APPEND NO
   NOT VOLATILE CARDINALITY
   DATA CAPTURE CHANGES
   AUDIT NONE
   CCSID UNICODE;


    CREATE        UNIQUE INDEX OA1P.IQZ080A1
           ON OA1P.TQZ080OptHintQuery
          (EXPLAIN_TIME
          )
           NOT CLUSTER
           DEFINE YES
           COMPRESS NO
           BUFFERPOOL BP1
           CLOSE YES
           DEFER NO
           COPY NO
           USING STOGROUP GSMS
               PRIQTY -1
               SECQTY -1
               ERASE NO
           GBPCACHE CHANGED
           ;

    CREATE AUXILIARY TABLE OA1P.tQZ080OptHintQuAux
        IN QZ01A1P.A080X
        STORES OA1P.tQZ080OptHintQuery
        APPEND NO
        COLUMN QUERY_TEXT;

    CREATE        UNIQUE INDEX OA1P.IQZ080X1
           ON OA1P.tQZ080OptHintQuAux
           DEFINE YES
           COMPRESS NO
           BUFFERPOOL BP1
           CLOSE YES
           COPY NO
           USING STOGROUP GSMS
               PRIQTY -1
               SECQTY -1
               ERASE NO
           GBPCACHE CHANGED
           PIECESIZE 2G
;
COMMIT;
;????;
    CREATE TABLE OA1P.TQZ081OptHintPlan
        LIKE S100447.PLAN_TABLE
        IN QZ01A1P.A081A;
    CREATE               INDEX OA1P.IQZ081A1
           ON OA1P.TQZ081OptHintPlan
           (EXPLAIN_TIME)
           DEFINE YES
           COMPRESS NO
           BUFFERPOOL BP1
           CLOSE YES
           COPY NO
           USING STOGROUP GSMS
               PRIQTY -1
               SECQTY -1
               ERASE NO
           GBPCACHE CHANGED
           PIECESIZE 2G;
COMMIT;