CREATE  TABLESPACE DSNDWBTS
        IN DSNDB04
        USING STOGROUP SYSDEFLT
                                    PRIQTY 1000
                                    ERASE NO
           FREEPAGE 0
           PCTFREE 5
           BUFFERPOOL BP0
           LOCKSIZE ANY
           CLOSE YES
           SEGSIZE 4
           LOCKMAX SYSTEM
           CCSID UNICODE
    ;








CREATE  TABLESPACE DSNEXPTS
        IN DSNDB04
        USING STOGROUP SYSDEFLT
                                    PRIQTY 1000
                                    ERASE NO
           FREEPAGE 0
           PCTFREE 5
           BUFFERPOOL BP8K1
           LOCKSIZE ANY
           CLOSE YES
           SEGSIZE 4
           LOCKMAX SYSTEM
           CCSID UNICODE
    ;








CREATE  TABLESPACE DSNFXNTS
        IN DSNDB04
        USING STOGROUP SYSDEFLT
                                    PRIQTY 1000
                                    ERASE NO
           FREEPAGE 0
           PCTFREE 5
           BUFFERPOOL BP8K1
           LOCKSIZE ANY
           CLOSE YES
           SEGSIZE 4
           LOCKMAX SYSTEM
           CCSID UNICODE
    ;








CREATE  LOB TABLESPACE DSNLOBT2
        IN DSNDB04
        USING STOGROUP SYSDEFLT
                                    ERASE NO
           BUFFERPOOL BP8K1
           LOCKSIZE ANY
           CLOSE YES
           LOCKMAX SYSTEM
           DSSIZE  4G
    ;








CREATE  TABLESPACE DSNPGRTS
        IN DSNDB04
        USING STOGROUP SYSDEFLT
                                    PRIQTY 1008
                                    ERASE NO
           FREEPAGE 0
           PCTFREE 5
           BUFFERPOOL BP16K1
           LOCKSIZE ANY
           CLOSE YES
           SEGSIZE 4
           LOCKMAX SYSTEM
           CCSID UNICODE
    ;








CREATE  TABLESPACE DSNPTKTS
        IN DSNDB04
        USING STOGROUP SYSDEFLT
                                    PRIQTY 1000
                                    ERASE NO
           FREEPAGE 0
           PCTFREE 5
           BUFFERPOOL BP8K1
           LOCKSIZE ANY
           CLOSE YES
           SEGSIZE 4
           LOCKMAX SYSTEM
           CCSID UNICODE
    ;








CREATE  TABLESPACE DSNQRYTS
        IN DSNDB04
        USING STOGROUP SYSDEFLT
                                    PRIQTY 1000
                                    ERASE NO
           FREEPAGE 0
           PCTFREE 5
           BUFFERPOOL BP8K1
           LOCKSIZE ANY
           CLOSE YES
           SEGSIZE 4
           LOCKMAX SYSTEM
           CCSID UNICODE
    ;








CREATE  TABLESPACE DSNSUMT2
        USING STOGROUP SYSDEFLT
                                    PRIQTY 720
                                    SECQTY 720
                                    ERASE NO
           FREEPAGE 0
           PCTFREE 5
           BUFFERPOOL BP0
           LOCKSIZE ANY
           CLOSE YES
           SEGSIZE 32
           LOCKMAX SYSTEM
           CCSID EBCDIC
    ;








CREATE  LOB TABLESPACE LOBTS3
        USING STOGROUP SYSDEFLT
                                    ERASE NO
           BUFFERPOOL BP32K
           LOCKSIZE ANY
           CLOSE YES
           LOCKMAX SYSTEM
           DSSIZE  4G
    ;








CREATE  TABLE DSN_DETCOST_TABLE
        ( "QUERYNO" INTEGER NOT NULL
        , QBLOCKNO SMALLINT NOT NULL
        , APPLNAME VARCHAR ( 24 ) NOT NULL
        , PROGNAME VARCHAR ( 128 ) NOT NULL
        , PLANNO SMALLINT NOT NULL
        , OPENIO REAL NOT NULL
        , OPENCPU REAL NOT NULL
        , OPENCOST REAL NOT NULL
        , DMIO REAL NOT NULL
        , DMCPU REAL NOT NULL
        , DMTOT REAL NOT NULL
        , SUBQIO REAL NOT NULL
        , SUBQCPU REAL NOT NULL
        , SUBQCOST REAL NOT NULL
        , BASEIO REAL NOT NULL
        , BASECPU REAL NOT NULL
        , BASETOT REAL NOT NULL
        , ONECOMPROWS REAL NOT NULL
        , IMLEAF REAL NOT NULL
        , IMIO REAL NOT NULL
        , IMPREFH CHAR ( 2 ) NOT NULL
        , IMMPRED INTEGER NOT NULL
        , IMFF REAL NOT NULL
        , IMSRPRED INTEGER NOT NULL
        , IMFFADJ REAL NOT NULL
        , IMSCANCST REAL NOT NULL
        , IMROWCST REAL NOT NULL
        , IMPAGECST REAL NOT NULL
        , IMRIDSORT REAL NOT NULL
        , IMMERGCST REAL NOT NULL
        , IMCPU REAL NOT NULL
        , IMTOT REAL NOT NULL
        , IMSEQNO SMALLINT NOT NULL
        , DMPREFH CHAR ( 2 ) NOT NULL
        , DMCLUDIO REAL NOT NULL
        , DMNCLUDIO REAL NOT NULL
        , DMPREDS INTEGER NOT NULL
        , DMSROWS REAL NOT NULL
        , DMSCANCST REAL NOT NULL
        , DMCOLS SMALLINT NOT NULL
        , DMROWS REAL NOT NULL
        , RDSROWCST REAL NOT NULL
        , DMPAGECST REAL NOT NULL
        , DMDATAIO REAL NOT NULL
        , DMDATACPU REAL NOT NULL
        , DMDATATOT REAL NOT NULL
        , RDSROW REAL NOT NULL
        , SNCOLS SMALLINT NOT NULL
        , SNROWS REAL NOT NULL
        , SNRECSZ INTEGER NOT NULL
        , SNPAGES REAL NOT NULL
        , SNRUNS REAL NOT NULL
        , SNMERGES REAL NOT NULL
        , SNIOCOST REAL NOT NULL
        , SNCPUCOST REAL NOT NULL
        , SNCOST REAL NOT NULL
        , SNSCANIO REAL NOT NULL
        , SNSCANCPU REAL NOT NULL
        , SNSCANCOST REAL NOT NULL
        , SCCOLS SMALLINT NOT NULL
        , SCROWS REAL NOT NULL
        , SCRECSZ INTEGER NOT NULL
        , SCPAGES REAL NOT NULL
        , SCRUNS REAL NOT NULL
        , SCMERGES REAL NOT NULL
        , SCIOCOST REAL NOT NULL
        , SCCPUCOST REAL NOT NULL
        , SCCOST REAL NOT NULL
        , SCSCANIO REAL NOT NULL
        , SCSCANCPU REAL NOT NULL
        , SCSCANCOST REAL NOT NULL
        , COMPCARD REAL NOT NULL
        , COMPIOCOST REAL NOT NULL
        , COMPCPUCOST REAL NOT NULL
        , COMPCOST REAL NOT NULL
        , JOINCOLS SMALLINT NOT NULL
        , EXPLAIN_TIME TIMESTAMP NOT NULL
        , COSTBLK INTEGER NOT NULL
        , COSTSTOR INTEGER NOT NULL
        , MPBLK INTEGER NOT NULL
        , MPSTOR INTEGER NOT NULL
        , COMPOSITES INTEGER NOT NULL
        , CLIPPED INTEGER NOT NULL
        , "PARTITION" INTEGER NOT NULL
        , TABREF VARCHAR ( 64 ) NOT NULL
        , MAX_COMPOSITES INTEGER NOT NULL
        , MAX_STOR INTEGER NOT NULL
        , MAX_CPU INTEGER NOT NULL
        , MAX_ELAP INTEGER NOT NULL
        , TBL_JOINED_THRESH INTEGER NOT NULL
        , STOR_USED INTEGER NOT NULL
        , CPU_USED INTEGER NOT NULL
        , ELAPSED INTEGER NOT NULL
        , MIN_CARD_KEEP REAL NOT NULL
        , MAX_CARD_KEEP REAL NOT NULL
        , MIN_COST_KEEP REAL NOT NULL
        , MAX_COST_KEEP REAL NOT NULL
        , MIN_VALUE_KEEP REAL NOT NULL
        , MIN_VALUE_CARD_KEEP REAL NOT NULL
        , MIN_VALUE_COST_KEEP REAL NOT NULL
        , MAX_VALUE_KEEP REAL NOT NULL
        , MAX_VALUE_CARD_KEEP REAL NOT NULL
        , MAX_VALUE_COST_KEEP REAL NOT NULL
        , MIN_CARD_CLIP REAL NOT NULL
        , MAX_CARD_CLIP REAL NOT NULL
        , MIN_COST_CLIP REAL NOT NULL
        , MAX_COST_CLIP REAL NOT NULL
        , MIN_VALUE_CLIP REAL NOT NULL
        , MIN_VALUE_CARD_CLIP REAL NOT NULL
        , MIN_VALUE_COST_CLIP REAL NOT NULL
        , MAX_VALUE_CLIP REAL NOT NULL
        , MAX_VALUE_CARD_CLIP REAL NOT NULL
        , MAX_VALUE_COST_CLIP REAL NOT NULL
        , GROUP_MEMBER VARCHAR ( 24 ) NOT NULL
        , PSEQIOCOST REAL NOT NULL
        , PSEQCPUCOST REAL NOT NULL
        , PSEQCOST REAL NOT NULL
        , PADJIOCOST REAL NOT NULL
        , PADJCPUCOST REAL NOT NULL
        , PADJCOST REAL NOT NULL
        )
        IN DSNDB04.DSNEXPTS
   CCSID         UNICODE
   VOLATILE
   ;






CREATE  TABLE DSN_FILTER_TABLE
        ( "QUERYNO" INTEGER NOT NULL
        , QBLOCKNO SMALLINT NOT NULL
        , PLANNO SMALLINT NOT NULL
        , APPLNAME VARCHAR ( 24 ) NOT NULL
        , PROGNAME VARCHAR ( 128 ) NOT NULL
        , "COLLID" VARCHAR ( 128 ) NOT NULL
          WITH DEFAULT
        , ORDERNO INTEGER NOT NULL
        , PREDNO INTEGER NOT NULL
        , STAGE CHAR ( 9 ) NOT NULL
        , ORDERCLASS INTEGER NOT NULL
        , EXPLAIN_TIME TIMESTAMP NOT NULL
        , MIXOPSEQNO SMALLINT NOT NULL
        , REEVAL CHAR ( 1 ) NOT NULL
        , GROUP_MEMBER VARCHAR ( 24 ) NOT NULL
        )
        IN DSNDB04.DSNEXPTS
   CCSID         UNICODE
   VOLATILE
   ;






CREATE  TABLE DSN_FUNCTION_TABLE
        ( "QUERYNO" INTEGER NOT NULL
        , QBLOCKNO INTEGER NOT NULL
        , APPLNAME VARCHAR ( 24 ) NOT NULL
        , PROGNAME VARCHAR ( 128 ) NOT NULL
        , "COLLID" VARCHAR ( 128 ) NOT NULL
        , GROUP_MEMBER VARCHAR ( 24 ) NOT NULL
        , EXPLAIN_TIME TIMESTAMP NOT NULL
        , SCHEMA_NAME VARCHAR ( 128 ) NOT NULL
        , FUNCTION_NAME VARCHAR ( 128 ) NOT NULL
        , SPEC_FUNC_NAME VARCHAR ( 128 ) NOT NULL
        , FUNCTION_TYPE CHAR ( 2 ) NOT NULL
        , VIEW_CREATOR VARCHAR ( 128 ) NOT NULL
        , VIEW_NAME VARCHAR ( 128 ) NOT NULL
        , "PATH" VARCHAR ( 2048 ) NOT NULL
        , FUNCTION_TEXT VARCHAR ( 1500 ) NOT NULL
        )
        IN DSNDB04.DSNFXNTS
   CCSID         UNICODE
   VOLATILE
   ;






CREATE  TABLE DSN_PGRANGE_TABLE
        ( "QUERYNO" INTEGER NOT NULL
        , QBLOCKNO SMALLINT NOT NULL
        , TABNO SMALLINT NOT NULL
        , RANGE SMALLINT NOT NULL
        , FIRSTPART SMALLINT NOT NULL
        , LASTPART SMALLINT NOT NULL
        , "NUMPARTS" SMALLINT NOT NULL
        , EXPLAIN_TIME TIMESTAMP NOT NULL
        , GROUP_MEMBER VARCHAR ( 24 ) NOT NULL
        )
        IN DSNDB04.DSNEXPTS
   CCSID         UNICODE
   VOLATILE
   ;






CREATE  TABLE DSN_PGROUP_TABLE
        ( "QUERYNO" INTEGER NOT NULL
        , QBLOCKNO SMALLINT NOT NULL
        , PLANNAME CHAR ( 8 ) NOT NULL
        , "COLLID" VARCHAR ( 128 ) NOT NULL
        , PROGNAME VARCHAR ( 128 ) NOT NULL
        , EXPLAIN_TIME TIMESTAMP NOT NULL
        , VERSION VARCHAR ( 122 ) NOT NULL
        , GROUPID SMALLINT NOT NULL
        , FIRSTPLAN SMALLINT NOT NULL
        , LASTPLAN SMALLINT NOT NULL
        , CPUCOST REAL NOT NULL
        , IOCOST REAL NOT NULL
        , BESTTIME REAL NOT NULL
        , DEGREE SMALLINT NOT NULL
        , MODE CHAR ( 1 ) NOT NULL
        , REASON SMALLINT NOT NULL
        , LOCALCPU SMALLINT NOT NULL
        , TOTALCPU SMALLINT NOT NULL
        , FIRSTBASE SMALLINT
        , LARGETS CHAR ( 1 )
        , PARTKIND CHAR ( 1 )
        , GROUPTYPE CHAR ( 3 )
        , "ORDER" CHAR ( 1 )
        , "STYLE" CHAR ( 4 )
        , RANGEKIND CHAR ( 1 )
        , NKEYCOLS SMALLINT
        , LOWBOUND VARCHAR ( 40 )
        , HIGHBOUND VARCHAR ( 40 )
        , LOWKEY VARCHAR ( 40 )
        , HIGHKEY VARCHAR ( 40 )
        , FIRSTPAGE CHAR ( 4 )
        , LASTPAGE CHAR ( 4 )
        , GROUP_MEMBER VARCHAR ( 24 ) NOT NULL
        , HOST_REASON SMALLINT
        , PARA_TYPE CHAR ( 4 )
        , PART_INNER CHAR ( 1 )
        , GRNU_KEYRNG CHAR ( 1 )
        , OPEN_KEYRNG CHAR ( 1 )
        )
        IN DSNDB04.DSNPGRTS
   CCSID         UNICODE
   VOLATILE
   ;






CREATE  TABLE DSN_PREDICAT_TABLE
        ( "QUERYNO" INTEGER NOT NULL
        , QBLOCKNO SMALLINT NOT NULL
        , APPLNAME VARCHAR ( 24 ) NOT NULL
        , PROGNAME VARCHAR ( 128 ) NOT NULL
        , PREDNO INTEGER NOT NULL
        , "TYPE" CHAR ( 8 ) NOT NULL
        , LEFT_HAND_SIDE VARCHAR ( 128 ) NOT NULL
        , LEFT_HAND_PNO INTEGER NOT NULL
        , LHS_TABNO SMALLINT NOT NULL
        , LHS_QBNO SMALLINT NOT NULL
        , RIGHT_HAND_SIDE VARCHAR ( 128 ) NOT NULL
        , RIGHT_HAND_PNO INTEGER NOT NULL
        , RHS_TABNO SMALLINT NOT NULL
        , RHS_QBNO SMALLINT NOT NULL
        , FILTER_FACTOR FLOAT NOT NULL
        , BOOLEAN_TERM CHAR ( 1 ) NOT NULL
        , SEARCHARG CHAR ( 1 ) NOT NULL
        , "JOIN" CHAR ( 1 ) NOT NULL
        , AFTER_JOIN CHAR ( 1 ) NOT NULL
        , ADDED_PRED CHAR ( 1 ) NOT NULL
        , REDUNDANT_PRED CHAR ( 1 ) NOT NULL
        , DIRECT_ACCESS CHAR ( 1 ) NOT NULL
        , KEYFIELD CHAR ( 1 ) NOT NULL
        , EXPLAIN_TIME TIMESTAMP NOT NULL
        , CATEGORY SMALLINT NOT NULL
        , CATEGORY_B SMALLINT NOT NULL
        , TEXT VARCHAR ( 2000 ) NOT NULL
        , PRED_ENCODE CHAR ( 1 ) NOT NULL
          WITH DEFAULT
        , PRED_CCSID SMALLINT NOT NULL
          WITH DEFAULT
        , PRED_MCCSID SMALLINT NOT NULL
          WITH DEFAULT
        , MARKER CHAR ( 1 ) NOT NULL
          WITH DEFAULT
        , PARENT_PNO INTEGER NOT NULL
        , NEGATION CHAR ( 1 ) NOT NULL
        , LITERALS VARCHAR ( 128 ) NOT NULL
        , CLAUSE CHAR ( 8 ) NOT NULL
        , GROUP_MEMBER VARCHAR ( 24 ) NOT NULL
        )
        IN DSNDB04.DSNEXPTS
   CCSID         UNICODE
   VOLATILE
   ;






CREATE  TABLE DSN_PTASK_TABLE
        ( "QUERYNO" INTEGER NOT NULL
        , QBLOCKNO SMALLINT NOT NULL
        , PGDNO SMALLINT NOT NULL
        , APPLNAME VARCHAR ( 24 ) NOT NULL
        , PROGNAME VARCHAR ( 128 ) NOT NULL
        , LPTNO SMALLINT NOT NULL
        , KEYCOLID SMALLINT
        , DPSI CHAR ( 1 ) NOT NULL
        , LPTLOKEY VARCHAR ( 40 )
        , LPTHIKEY VARCHAR ( 40 )
        , LPTLOPAG CHAR ( 4 )
        , LPTHIPAG CHAR ( 4 )
        , LPTLOPG CHAR ( 4 )
        , LPTHIPG CHAR ( 4 )
        , LPTLOPT SMALLINT
        , LPTHIPT SMALLINT
        , KEYCOLDT SMALLINT
        , KEYCOLPREC SMALLINT
        , KEYCOLSCAL SMALLINT
        , EXPLAIN_TIME TIMESTAMP NOT NULL
        , GROUP_MEMBER VARCHAR ( 24 ) NOT NULL
        )
        IN DSNDB04.DSNPTKTS
   CCSID         UNICODE
   VOLATILE
   ;






CREATE  TABLE DSN_QUERY_TABLE
        ( "QUERYNO" INTEGER NOT NULL
        , "TYPE" CHAR ( 8 ) NOT NULL
        , QUERY_STAGE CHAR ( 8 ) NOT NULL
        , SEQNO INTEGER NOT NULL
        , NODE_DATA CLOB ( 2 M ) NOT NULL
        , EXPLAIN_TIME TIMESTAMP NOT NULL
        , QUERY_ROWID ROWID
        GENERATED BY DEFAULT NOT NULL
        , GROUP_MEMBER VARCHAR ( 24 ) NOT NULL
        , HASHKEY INTEGER NOT NULL
        , HAS_PRED CHAR ( 1 ) NOT NULL
        )
        IN DSNDB04.DSNQRYTS
   CCSID         UNICODE
   VOLATILE
   ;






CREATE  TABLE DSN_SORT_TABLE
        ( "QUERYNO" INTEGER NOT NULL
        , QBLOCKNO SMALLINT NOT NULL
        , PLANNO SMALLINT NOT NULL
        , APPLNAME VARCHAR ( 24 ) NOT NULL
        , PROGNAME VARCHAR ( 128 ) NOT NULL
        , "COLLID" VARCHAR ( 128 ) NOT NULL
          WITH DEFAULT
        , SORTC CHAR ( 5 ) NOT NULL
          WITH DEFAULT
        , SORTN CHAR ( 5 ) NOT NULL
          WITH DEFAULT
        , SORTNO SMALLINT NOT NULL
        , KEYSIZE SMALLINT NOT NULL
        , ORDERCLASS INTEGER NOT NULL
        , EXPLAIN_TIME TIMESTAMP NOT NULL
        , GROUP_MEMBER VARCHAR ( 24 ) NOT NULL
        )
        IN DSNDB04.DSNEXPTS
   CCSID         UNICODE
   VOLATILE
   ;






CREATE  TABLE DSN_SORTKEY_TABLE
        ( "QUERYNO" INTEGER NOT NULL
        , QBLOCKNO SMALLINT NOT NULL
        , PLANNO SMALLINT NOT NULL
        , APPLNAME VARCHAR ( 24 ) NOT NULL
        , PROGNAME VARCHAR ( 128 ) NOT NULL
        , "COLLID" VARCHAR ( 128 ) NOT NULL
          WITH DEFAULT
        , SORTNO SMALLINT NOT NULL
        , ORDERNO SMALLINT NOT NULL
        , EXPTYPE CHAR ( 3 ) NOT NULL
        , TEXT VARCHAR ( 128 ) NOT NULL
        , TABNO SMALLINT NOT NULL
        , COLNO SMALLINT NOT NULL
        , DATATYPE CHAR ( 18 ) NOT NULL
        , LENGTH INTEGER NOT NULL
        , "CCSID" INTEGER NOT NULL
        , ORDERCLASS INTEGER NOT NULL
        , EXPLAIN_TIME TIMESTAMP NOT NULL
        , GROUP_MEMBER VARCHAR ( 24 ) NOT NULL
        )
        IN DSNDB04.DSNEXPTS
   CCSID         UNICODE
   VOLATILE
   ;






CREATE  TABLE DSN_STATEMENT_CACHE_TABLE
        ( STMT_ID INTEGER NOT NULL
        , STMT_TOKEN VARCHAR ( 240 )
        , "COLLID" VARCHAR ( 128 ) NOT NULL
        , PROGRAM_NAME VARCHAR ( 128 ) NOT NULL
        , INV_DROPALT CHAR ( 1 ) NOT NULL
        , INV_REVOKE CHAR ( 1 ) NOT NULL
        , INV_LRU CHAR ( 1 ) NOT NULL
        , INV_RUNSTATS CHAR ( 1 ) NOT NULL
        , CACHED_TS TIMESTAMP NOT NULL
        , USERS INTEGER NOT NULL
        , COPIES INTEGER NOT NULL
        , LINES INTEGER NOT NULL
        , PRIMAUTH VARCHAR ( 128 ) NOT NULL
        , CURSQLID VARCHAR ( 128 ) NOT NULL
        , BIND_QUALIFIER VARCHAR ( 128 ) NOT NULL
        , BIND_ISO CHAR ( 2 ) NOT NULL
        , BIND_CDATA CHAR ( 1 ) NOT NULL
        , BIND_DYNRL CHAR ( 1 ) NOT NULL
        , BIND_DEGRE CHAR ( 1 ) NOT NULL
        , BIND_SQLRL CHAR ( 1 ) NOT NULL
        , BIND_CHOLD CHAR ( 1 ) NOT NULL
        , STAT_TS TIMESTAMP NOT NULL
        , STAT_EXEC INTEGER NOT NULL
        , STAT_GPAG INTEGER NOT NULL
        , STAT_SYNR INTEGER NOT NULL
        , STAT_WRIT INTEGER NOT NULL
        , STAT_EROW INTEGER NOT NULL
        , STAT_PROW INTEGER NOT NULL
        , STAT_SORT INTEGER NOT NULL
        , STAT_INDX INTEGER NOT NULL
        , STAT_RSCN INTEGER NOT NULL
        , STAT_PGRP INTEGER NOT NULL
        , STAT_ELAP FLOAT NOT NULL
        , STAT_CPU FLOAT NOT NULL
        , STAT_SUS_SYNIO FLOAT NOT NULL
        , STAT_SUS_LOCK FLOAT NOT NULL
        , STAT_SUS_SWIT FLOAT NOT NULL
        , STAT_SUS_GLCK FLOAT NOT NULL
        , STAT_SUS_OTHR FLOAT NOT NULL
        , STAT_SUS_OTHW FLOAT NOT NULL
        , STAT_RIDLIMT INTEGER NOT NULL
        , STAT_RIDSTOR INTEGER NOT NULL
        , EXPLAIN_TS TIMESTAMP NOT NULL
        , "SCHEMA" VARCHAR ( 128 ) NOT NULL
        , STMT_TEXT CLOB ( 2 M ) NOT NULL
        , STMT_ROWID ROWID
        GENERATED ALWAYS NOT NULL
        , BIND_RO_TYPE CHAR ( 1 ) NOT NULL
          WITH DEFAULT
        , BIND_RA_TOT INTEGER NOT NULL
          WITH DEFAULT
        )
        IN DSNSUMT2
   CCSID         EBCDIC
   ;






CREATE  TABLE DSN_STATEMNT_TABLE
        ( "QUERYNO" INTEGER NOT NULL
        , APPLNAME VARCHAR ( 24 ) NOT NULL
        , PROGNAME VARCHAR ( 128 ) NOT NULL
        , "COLLID" VARCHAR ( 128 ) NOT NULL
        , GROUP_MEMBER VARCHAR ( 24 ) NOT NULL
        , EXPLAIN_TIME TIMESTAMP NOT NULL
        , STMT_TYPE CHAR ( 6 ) NOT NULL
        , COST_CATEGORY CHAR ( 1 ) NOT NULL
        , PROCMS INTEGER NOT NULL
        , PROCSU INTEGER NOT NULL
        , REASON VARCHAR ( 254 ) NOT NULL
        , STMT_ENCODE CHAR ( 1 ) NOT NULL
        , TOTAL_COST FLOAT NOT NULL
        )
        IN DSNDB04.DSNEXPTS
   CCSID         UNICODE
   VOLATILE
   ;






CREATE  TABLE DSN_STRUCT_TABLE
        ( "QUERYNO" INTEGER NOT NULL
        , QBLOCKNO SMALLINT NOT NULL
        , APPLNAME VARCHAR ( 24 ) NOT NULL
        , PROGNAME VARCHAR ( 128 ) NOT NULL
        , PARENT SMALLINT NOT NULL
        , TIMES FLOAT NOT NULL
        , ROWCOUNT INTEGER NOT NULL
        , ATOPEN CHAR ( 1 ) NOT NULL
        , CONTEXT CHAR ( 10 ) NOT NULL
        , ORDERNO SMALLINT NOT NULL
        , DOATOPEN_PARENT SMALLINT NOT NULL
        , QBLOCK_TYPE CHAR ( 6 ) NOT NULL
          WITH DEFAULT
        , EXPLAIN_TIME TIMESTAMP NOT NULL
        , QUERY_STAGE CHAR ( 8 ) NOT NULL
        , GROUP_MEMBER VARCHAR ( 24 ) NOT NULL
        )
        IN DSNDB04.DSNEXPTS
   CCSID         UNICODE
   VOLATILE
   ;






CREATE  TABLE DSN_VIEWREF_TABLE
        ( "QUERYNO" INTEGER NOT NULL
          WITH DEFAULT
        , APPLNAME VARCHAR ( 24 ) NOT NULL
          WITH DEFAULT
        , PROGNAME VARCHAR ( 128 ) NOT NULL
          WITH DEFAULT
        , VERSION VARCHAR ( 122 ) NOT NULL
          WITH DEFAULT
        , "COLLID" VARCHAR ( 128 ) NOT NULL
          WITH DEFAULT
        , CREATOR VARCHAR ( 128 ) NOT NULL
          WITH DEFAULT
        , "NAME" VARCHAR ( 128 ) NOT NULL
          WITH DEFAULT
        , "TYPE" CHAR ( 1 ) NOT NULL
          WITH DEFAULT
        , MQTUSE SMALLINT NOT NULL
          WITH DEFAULT
        , EXPLAIN_TIME TIMESTAMP NOT NULL
          WITH DEFAULT
        , GROUP_MEMBER VARCHAR ( 24 ) NOT NULL
        )
        IN DSNDB04.DSNEXPTS
   CCSID         UNICODE
   VOLATILE
   ;






CREATE  TABLE DSN_VIRTUAL_INDEXES
        ( TBCREATOR VARCHAR ( 128 ) NOT NULL
        , TBNAME VARCHAR ( 128 ) NOT NULL
        , IXCREATOR VARCHAR ( 128 ) NOT NULL
        , IXNAME VARCHAR ( 128 ) NOT NULL
        , ENABLE CHAR ( 1 ) NOT NULL
        , MODE CHAR ( 1 ) NOT NULL
        , UNIQUERULE CHAR ( 1 ) NOT NULL
        , COLCOUNT SMALLINT NOT NULL
        , CLUSTERING CHAR ( 1 ) NOT NULL
        , NLEAF INTEGER NOT NULL
        , NLEVELS SMALLINT NOT NULL
        , INDEXTYPE CHAR ( 1 ) NOT NULL
          WITH DEFAULT
        , PGSIZE SMALLINT NOT NULL
        , FIRSTKEYCARDF FLOAT NOT NULL
          WITH DEFAULT
-1
        , FULLKEYCARDF FLOAT NOT NULL
          WITH DEFAULT
-1
        , CLUSTERRATIOF FLOAT NOT NULL
          WITH DEFAULT
        , "PADDED" CHAR ( 1 ) NOT NULL
          WITH DEFAULT
        , COLNO1 SMALLINT
        , ORDERING1 CHAR ( 1 )
        , COLNO2 SMALLINT
        , ORDERING2 CHAR ( 1 )
        , COLNO3 SMALLINT
        , ORDERING3 CHAR ( 1 )
        , COLNO4 SMALLINT
        , ORDERING4 CHAR ( 1 )
        , COLNO5 SMALLINT
        , ORDERING5 CHAR ( 1 )
        , COLNO6 SMALLINT
        , ORDERING6 CHAR ( 1 )
        , COLNO7 SMALLINT
        , ORDERING7 CHAR ( 1 )
        , COLNO8 SMALLINT
        , ORDERING8 CHAR ( 1 )
        , COLNO9 SMALLINT
        , ORDERING9 CHAR ( 1 )
        , COLNO10 SMALLINT
        , ORDERING10 CHAR ( 1 )
        , COLNO11 SMALLINT
        , ORDERING11 CHAR ( 1 )
        , COLNO12 SMALLINT
        , ORDERING12 CHAR ( 1 )
        , COLNO13 SMALLINT
        , ORDERING13 CHAR ( 1 )
        , COLNO14 SMALLINT
        , ORDERING14 CHAR ( 1 )
        , COLNO15 SMALLINT
        , ORDERING15 CHAR ( 1 )
        , COLNO16 SMALLINT
        , ORDERING16 CHAR ( 1 )
        , COLNO17 SMALLINT
        , ORDERING17 CHAR ( 1 )
        , COLNO18 SMALLINT
        , ORDERING18 CHAR ( 1 )
        , COLNO19 SMALLINT
        , ORDERING19 CHAR ( 1 )
        , COLNO20 SMALLINT
        , ORDERING20 CHAR ( 1 )
        , COLNO21 SMALLINT
        , ORDERING21 CHAR ( 1 )
        , COLNO22 SMALLINT
        , ORDERING22 CHAR ( 1 )
        , COLNO23 SMALLINT
        , ORDERING23 CHAR ( 1 )
        , COLNO24 SMALLINT
        , ORDERING24 CHAR ( 1 )
        , COLNO25 SMALLINT
        , ORDERING25 CHAR ( 1 )
        , COLNO26 SMALLINT
        , ORDERING26 CHAR ( 1 )
        , COLNO27 SMALLINT
        , ORDERING27 CHAR ( 1 )
        , COLNO28 SMALLINT
        , ORDERING28 CHAR ( 1 )
        , COLNO29 SMALLINT
        , ORDERING29 CHAR ( 1 )
        , COLNO30 SMALLINT
        , ORDERING30 CHAR ( 1 )
        , COLNO31 SMALLINT
        , ORDERING31 CHAR ( 1 )
        , COLNO32 SMALLINT
        , ORDERING32 CHAR ( 1 )
        , COLNO33 SMALLINT
        , ORDERING33 CHAR ( 1 )
        , COLNO34 SMALLINT
        , ORDERING34 CHAR ( 1 )
        , COLNO35 SMALLINT
        , ORDERING35 CHAR ( 1 )
        , COLNO36 SMALLINT
        , ORDERING36 CHAR ( 1 )
        , COLNO37 SMALLINT
        , ORDERING37 CHAR ( 1 )
        , COLNO38 SMALLINT
        , ORDERING38 CHAR ( 1 )
        , COLNO39 SMALLINT
        , ORDERING39 CHAR ( 1 )
        , COLNO40 SMALLINT
        , ORDERING40 CHAR ( 1 )
        , COLNO41 SMALLINT
        , ORDERING41 CHAR ( 1 )
        , COLNO42 SMALLINT
        , ORDERING42 CHAR ( 1 )
        , COLNO43 SMALLINT
        , ORDERING43 CHAR ( 1 )
        , COLNO44 SMALLINT
        , ORDERING44 CHAR ( 1 )
        , COLNO45 SMALLINT
        , ORDERING45 CHAR ( 1 )
        , COLNO46 SMALLINT
        , ORDERING46 CHAR ( 1 )
        , COLNO47 SMALLINT
        , ORDERING47 CHAR ( 1 )
        , COLNO48 SMALLINT
        , ORDERING48 CHAR ( 1 )
        , COLNO49 SMALLINT
        , ORDERING49 CHAR ( 1 )
        , COLNO50 SMALLINT
        , ORDERING50 CHAR ( 1 )
        , COLNO51 SMALLINT
        , ORDERING51 CHAR ( 1 )
        , COLNO52 SMALLINT
        , ORDERING52 CHAR ( 1 )
        , COLNO53 SMALLINT
        , ORDERING53 CHAR ( 1 )
        , COLNO54 SMALLINT
        , ORDERING54 CHAR ( 1 )
        , COLNO55 SMALLINT
        , ORDERING55 CHAR ( 1 )
        , COLNO56 SMALLINT
        , ORDERING56 CHAR ( 1 )
        , COLNO57 SMALLINT
        , ORDERING57 CHAR ( 1 )
        , COLNO58 SMALLINT
        , ORDERING58 CHAR ( 1 )
        , COLNO59 SMALLINT
        , ORDERING59 CHAR ( 1 )
        , COLNO60 SMALLINT
        , ORDERING60 CHAR ( 1 )
        , COLNO61 SMALLINT
        , ORDERING61 CHAR ( 1 )
        , COLNO62 SMALLINT
        , ORDERING62 CHAR ( 1 )
        , COLNO63 SMALLINT
        , ORDERING63 CHAR ( 1 )
        , COLNO64 SMALLINT
        , ORDERING64 CHAR ( 1 )
        )
   CCSID         UNICODE
   ;






CREATE  TABLE PLAN_TABLE
        ( "QUERYNO" INTEGER NOT NULL
        , QBLOCKNO SMALLINT NOT NULL
        , APPLNAME VARCHAR ( 24 ) NOT NULL
        , PROGNAME VARCHAR ( 128 ) NOT NULL
        , PLANNO SMALLINT NOT NULL
        , METHOD SMALLINT NOT NULL
        , CREATOR VARCHAR ( 128 ) NOT NULL
        , TNAME VARCHAR ( 128 ) NOT NULL
        , TABNO SMALLINT NOT NULL
        , ACCESSTYPE CHAR ( 2 ) NOT NULL
        , MATCHCOLS SMALLINT NOT NULL
        , ACCESSCREATOR VARCHAR ( 128 ) NOT NULL
        , ACCESSNAME VARCHAR ( 128 ) NOT NULL
        , INDEXONLY CHAR ( 1 ) NOT NULL
        , SORTN_UNIQ CHAR ( 1 ) NOT NULL
        , SORTN_JOIN CHAR ( 1 ) NOT NULL
        , SORTN_ORDERBY CHAR ( 1 ) NOT NULL
        , SORTN_GROUPBY CHAR ( 1 ) NOT NULL
        , SORTC_UNIQ CHAR ( 1 ) NOT NULL
        , SORTC_JOIN CHAR ( 1 ) NOT NULL
        , SORTC_ORDERBY CHAR ( 1 ) NOT NULL
        , SORTC_GROUPBY CHAR ( 1 ) NOT NULL
        , TSLOCKMODE CHAR ( 3 ) NOT NULL
        , TIMESTAMP CHAR ( 16 ) NOT NULL
        , REMARKS VARCHAR ( 762 ) NOT NULL
        , PREFETCH CHAR ( 1 ) NOT NULL
        , COLUMN_FN_EVAL CHAR ( 1 ) NOT NULL
        , MIXOPSEQ SMALLINT NOT NULL
        , VERSION VARCHAR ( 122 ) NOT NULL
        , "COLLID" VARCHAR ( 128 ) NOT NULL
        , ACCESS_DEGREE SMALLINT
        , ACCESS_PGROUP_ID SMALLINT
        , JOIN_DEGREE SMALLINT
        , JOIN_PGROUP_ID SMALLINT
        , SORTC_PGROUP_ID SMALLINT
        , SORTN_PGROUP_ID SMALLINT
        , PARALLELISM_MODE CHAR ( 1 )
        , MERGE_JOIN_COLS SMALLINT
        , CORRELATION_NAME VARCHAR ( 128 )
        , PAGE_RANGE CHAR ( 1 ) NOT NULL
          WITH DEFAULT
        , JOIN_TYPE CHAR ( 1 ) NOT NULL
          WITH DEFAULT
        , GROUP_MEMBER VARCHAR ( 24 ) NOT NULL
          WITH DEFAULT
        , IBM_SERVICE_DATA VARCHAR ( 254 ) NOT NULL
          WITH DEFAULT
          FOR BIT DATA
        , WHEN_OPTIMIZE CHAR ( 1 ) NOT NULL
          WITH DEFAULT
        , QBLOCK_TYPE CHAR ( 6 ) NOT NULL
          WITH DEFAULT
        , BIND_TIME TIMESTAMP NOT NULL
          WITH DEFAULT
        , OPTHINT VARCHAR ( 128 ) NOT NULL
          WITH DEFAULT
        , HINT_USED VARCHAR ( 128 ) NOT NULL
          WITH DEFAULT
        , PRIMARY_ACCESSTYPE CHAR ( 1 ) NOT NULL
          WITH DEFAULT
        , PARENT_QBLOCKNO SMALLINT NOT NULL
        , TABLE_TYPE CHAR ( 1 )
        , TABLE_ENCODE CHAR ( 1 ) NOT NULL
          WITH DEFAULT
        , TABLE_SCCSID SMALLINT NOT NULL
          WITH DEFAULT
        , TABLE_MCCSID SMALLINT NOT NULL
          WITH DEFAULT
        , TABLE_DCCSID SMALLINT NOT NULL
          WITH DEFAULT
        , ROUTINE_ID INTEGER NOT NULL
          WITH DEFAULT
        , CTEREF SMALLINT NOT NULL
          WITH DEFAULT
        , STMTTOKEN VARCHAR ( 240 )
        , PARENT_PLANNO SMALLINT NOT NULL
        )
        IN DSNDB04.DSNDWBTS
   CCSID         UNICODE
   VOLATILE
   ;






CREATE  AUXILIARY TABLE DSN_QUERY_AUX
   IN DSNDB04.DSNLOBT2
        STORES DSN_QUERY_TABLE
        COLUMN NODE_DATA
   ;






CREATE  AUXILIARY TABLE DSN_STATEMENT_CACHE_AUX
   IN  LOBTS3
        STORES DSN_STATEMENT_CACHE_TABLE
        COLUMN STMT_TEXT
   ;










CREATE  INDEX DSN_DETCOST_TABLE_IDX1 ON DSN_DETCOST_TABLE
        ( "QUERYNO" ASC
        , EXPLAIN_TIME ASC
          )
        USING STOGROUP SYSDEFLT
                                    ERASE NO
           FREEPAGE 0
           PCTFREE 10
           BUFFERPOOL BP0
           CLOSE YES
           PIECESIZE 2G
    ;








CREATE  INDEX DSN_FILTER_TABLE_IDX1 ON DSN_FILTER_TABLE
        ( "QUERYNO" ASC
        , EXPLAIN_TIME ASC
          )
        USING STOGROUP SYSDEFLT
                                    ERASE NO
           FREEPAGE 0
           PCTFREE 10
           BUFFERPOOL BP0
           CLOSE YES
           PIECESIZE 2G
    ;








CREATE  INDEX DSN_FUNCTION_TABLE_IDX1 ON DSN_FUNCTION_TABLE
        ( "QUERYNO" ASC
        , EXPLAIN_TIME ASC
          )
        USING STOGROUP SYSDEFLT
                                    ERASE NO
           FREEPAGE 0
           PCTFREE 10
           BUFFERPOOL BP0
           CLOSE YES
           PIECESIZE 2G
    ;








CREATE  INDEX DSN_PGRANGE_TABLE_IDX1 ON DSN_PGRANGE_TABLE
        ( "QUERYNO" ASC
        , EXPLAIN_TIME ASC
          )
        USING STOGROUP SYSDEFLT
                                    ERASE NO
           FREEPAGE 0
           PCTFREE 10
           BUFFERPOOL BP0
           CLOSE YES
           PIECESIZE 2G
    ;








CREATE  INDEX DSN_PGROUP_TABLE_IDX1 ON DSN_PGROUP_TABLE
        ( "QUERYNO" ASC
        , EXPLAIN_TIME ASC
          )
        USING STOGROUP SYSDEFLT
                                    ERASE NO
           FREEPAGE 0
           PCTFREE 10
           BUFFERPOOL BP0
           CLOSE YES
           PIECESIZE 2G
    ;








CREATE  INDEX DSN_PREDICAT_TABLE_IDX1 ON DSN_PREDICAT_TABLE
        ( "QUERYNO" ASC
        , EXPLAIN_TIME ASC
          )
        USING STOGROUP SYSDEFLT
                                    ERASE NO
           FREEPAGE 0
           PCTFREE 10
           BUFFERPOOL BP0
           CLOSE YES
           PIECESIZE 2G
    ;








CREATE  INDEX DSN_PTASK_TABLE_IDX1 ON DSN_PTASK_TABLE
        ( "QUERYNO" ASC
        , EXPLAIN_TIME ASC
          )
        USING STOGROUP SYSDEFLT
                                    ERASE NO
           FREEPAGE 0
           PCTFREE 10
           BUFFERPOOL BP0
           CLOSE YES
           PIECESIZE 2G
    ;








CREATE  INDEX DSN_QUERY_TABLE_IDX1 ON DSN_QUERY_TABLE
        ( "QUERYNO" ASC
        , EXPLAIN_TIME ASC
          )
        USING STOGROUP SYSDEFLT
                                    ERASE NO
           FREEPAGE 0
           PCTFREE 10
           BUFFERPOOL BP0
           CLOSE YES
           PIECESIZE 2G
    ;








CREATE  INDEX DSN_QUERY_TABLE_IDX2 ON DSN_QUERY_TABLE
        ( "QUERYNO" ASC
        , "TYPE" ASC
        , QUERY_STAGE ASC
        , EXPLAIN_TIME ASC
        , SEQNO ASC
          )
        USING STOGROUP SYSDEFLT
                                    ERASE NO
           FREEPAGE 0
           PCTFREE 10
           BUFFERPOOL BP0
           CLOSE YES
           PIECESIZE 2G
    ;








CREATE  INDEX DSN_SORT_TABLE_IDX1 ON DSN_SORT_TABLE
        ( "QUERYNO" ASC
        , EXPLAIN_TIME ASC
          )
        USING STOGROUP SYSDEFLT
                                    ERASE NO
           FREEPAGE 0
           PCTFREE 10
           BUFFERPOOL BP0
           CLOSE YES
           PIECESIZE 2G
    ;








CREATE  INDEX DSN_SORTKEY_TABLE_IDX1 ON DSN_SORTKEY_TABLE
        ( "QUERYNO" ASC
        , EXPLAIN_TIME ASC
          )
        USING STOGROUP SYSDEFLT
                                    ERASE NO
           FREEPAGE 0
           PCTFREE 10
           BUFFERPOOL BP0
           CLOSE YES
           PIECESIZE 2G
    ;








CREATE  INDEX DSN_STATEMENT_CACHE_IDX1 ON
        DSN_STATEMENT_CACHE_TABLE
        ( STMT_ID ASC
          )
        USING STOGROUP SYSDEFLT
                                    ERASE NO
           FREEPAGE 0
           PCTFREE 10
           BUFFERPOOL BP0
           CLOSE YES
           PIECESIZE 2G
    ;








CREATE  INDEX DSN_STATEMENT_CACHE_IDX2 ON
        DSN_STATEMENT_CACHE_TABLE
        ( STMT_TOKEN ASC
          )
           PADDED
        USING STOGROUP SYSDEFLT
                                    ERASE NO
           FREEPAGE 0
           PCTFREE 10
           CLUSTER
           BUFFERPOOL BP0
           CLOSE YES
           PIECESIZE 2G
    ;








CREATE  INDEX DSN_STATEMENT_CACHE_IDX3 ON
        DSN_STATEMENT_CACHE_TABLE
        ( EXPLAIN_TS DESC
          )
        USING STOGROUP SYSDEFLT
                                    ERASE NO
           FREEPAGE 0
           PCTFREE 10
           BUFFERPOOL BP0
           CLOSE YES
           PIECESIZE 2G
    ;








CREATE  INDEX DSN_STATEMNT_TABLE_IDX1 ON DSN_STATEMNT_TABLE
        ( "QUERYNO" ASC
        , EXPLAIN_TIME ASC
          )
        USING STOGROUP SYSDEFLT
                                    ERASE NO
           FREEPAGE 0
           PCTFREE 10
           BUFFERPOOL BP0
           CLOSE YES
           PIECESIZE 2G
    ;








CREATE  INDEX DSN_STRUCT_TABLE_IDX1 ON DSN_STRUCT_TABLE
        ( "QUERYNO" ASC
        , EXPLAIN_TIME ASC
          )
        USING STOGROUP SYSDEFLT
                                    ERASE NO
           FREEPAGE 0
           PCTFREE 10
           BUFFERPOOL BP0
           CLOSE YES
           PIECESIZE 2G
    ;








CREATE  INDEX DSN_VIEWREF_TABLE_IDX1 ON DSN_VIEWREF_TABLE
        ( "QUERYNO" ASC
        , EXPLAIN_TIME ASC
          )
        USING STOGROUP SYSDEFLT
                                    ERASE NO
           FREEPAGE 0
           PCTFREE 10
           BUFFERPOOL BP0
           CLOSE YES
           PIECESIZE 2G
    ;








CREATE  INDEX DSN_VIRTUAL_INDEXES_IDX1 ON
        DSN_VIRTUAL_INDEXES
        ( ENABLE ASC
        , MODE ASC
        , TBCREATOR ASC
        , TBNAME ASC
        , IXCREATOR ASC
        , IXNAME ASC
          )
           NOT PADDED
        USING STOGROUP SYSDEFLT
                                    ERASE NO
           FREEPAGE 0
           PCTFREE 10
           BUFFERPOOL BP0
           CLOSE YES
           PIECESIZE 2G
    ;








CREATE  INDEX DSN_VIRTUAL_INDEXES_IDX2 ON
        DSN_VIRTUAL_INDEXES
        ( TBCREATOR ASC
        , TBNAME ASC
          )
           NOT PADDED
        USING STOGROUP SYSDEFLT
                                    ERASE NO
           FREEPAGE 0
           PCTFREE 10
           BUFFERPOOL BP0
           CLOSE YES
           PIECESIZE 2G
    ;








CREATE  INDEX PLAN_TABLE_IDX1 ON PLAN_TABLE
        ( "QUERYNO" ASC
        , BIND_TIME ASC
          )
        USING STOGROUP SYSDEFLT
                                    ERASE NO
           FREEPAGE 0
           PCTFREE 10
           BUFFERPOOL BP0
           CLOSE YES
           PIECESIZE 2G
    ;








CREATE  INDEX PLAN_TABLE_IDX3 ON PLAN_TABLE
        ( TABLE_TYPE ASC
        , "QUERYNO" ASC
        , TNAME ASC
        , CREATOR ASC
          )
           PADDED
        USING STOGROUP SYSDEFLT
                                    ERASE NO
           FREEPAGE 0
           PCTFREE 10
           BUFFERPOOL BP0
           CLOSE YES
           PIECESIZE 2G
    ;








CREATE  INDEX PLAN_TABLE_IDX4 ON PLAN_TABLE
        ( ACCESSTYPE ASC
        , "QUERYNO" ASC
        , ACCESSNAME ASC
        , ACCESSCREATOR ASC
          )
           PADDED
        USING STOGROUP SYSDEFLT
                                    ERASE NO
           FREEPAGE 0
           PCTFREE 10
           BUFFERPOOL BP0
           CLOSE YES
           PIECESIZE 2G
    ;








CREATE  UNIQUE INDEX DSN_QUERY_TABLE_IDX3 ON DSN_QUERY_TABLE
        ( QUERY_ROWID ASC
          )
        USING STOGROUP SYSDEFLT
                                    ERASE NO
           FREEPAGE 0
           PCTFREE 10
           BUFFERPOOL BP0
           CLOSE YES
           PIECESIZE 2G
    ;








CREATE  UNIQUE INDEX DSN_QUERY_AUXINX ON DSN_QUERY_AUX
        USING STOGROUP SYSDEFLT
                                    ERASE NO
           FREEPAGE 0
           PCTFREE 10
           BUFFERPOOL BP0
           CLOSE YES
           PIECESIZE 4G
    ;








CREATE  UNIQUE INDEX DSN_STATEMENT_CACHE_AUXINX ON
        DSN_STATEMENT_CACHE_AUX
        USING STOGROUP SYSDEFLT
                                    ERASE NO
           FREEPAGE 0
           PCTFREE 10
           BUFFERPOOL BP0
           CLOSE YES
           PIECESIZE 4G
    ;








CREATE  UNIQUE INDEX PLAN_TABLE_IDX2 ON PLAN_TABLE
        ( "QUERYNO" ASC
        , QBLOCKNO ASC
        , PLANNO ASC
        , MIXOPSEQ ASC
        , BIND_TIME ASC
          )
        USING STOGROUP SYSDEFLT
                                    ERASE NO
           FREEPAGE 0
           PCTFREE 10
           BUFFERPOOL BP0
           CLOSE YES
           PIECESIZE 2G
    ;