zOs/SQL/GBGRMITM

-- temporary table for data migration by gbgrmiDa
--
set current sqlid = 'S100447';

    drop   TABLESPACE qz01A1p.A006T;
    commit;
    CREATE TABLESPACE A006T
           IN QZ01A1P
           USING STOGROUP GSMS
               PRIQTY -1
               SECQTY -1
               ERASE NO
           BUFFERPOOL BP2
           CLOSE YES
           LOCKMAX SYSTEM
           SEGSIZE 64
           numParts   9
           dsSize 64 G
           GBPCACHE CHANGED
           DEFINE YES
           LOGGED
           TRACKMOD YES
           COMPRESS YES
           LOCKSIZE ANY
           MAXROWS 255
           CCSID UNICODE;

    CREATE TABLE OA1P.TQZ006Tmp
        (p smallint not null default 1
        ,DB CHARACTER(8) not null
        ,TS CHARACTER(8) not null
        ,PARTS smallint not null
        ,PARTITION smallint not null
        ,DSSIZE int not null
        ,LARGE CHARACTER(1) not null
        ,HIUse bigInt not NUll
        ,DATUM date not null
        )
        partition by (p)
        (partition 1 ending at (1)
        ,partition 2 ending at (2)
        ,partition 3 ending at (3)
        ,partition 4 ending at (4)
        ,partition 5 ending at (5)
        ,partition 6 ending at (6)
        ,partition 7 ending at (7)
        ,partition 8 ending at (8)
        ,partition 9 ending at (9)
        )
        IN QZ01A1P.A006T
   APPEND NO
   NOT VOLATILE CARDINALITY
   DATA CAPTURE CHANGES
   AUDIT NONE
   CCSID UNICODE;

    CREATE INDEX OA1P.Iqz006I1
           ON OA1P.TQZ006TMP
          (p, db, ts, partition, datum)
           partitioned
           CLUSTER
           DEFINE YES
           COMPRESS NO
           BUFFERPOOL BP1
           CLOSE YES
           DEFER NO
           COPY NO
           USING STOGROUP GSMS
               PRIQTY -1
               SECQTY -1
               ERASE NO
           GBPCACHE CHANGED;
commit;