zOs/TX/PER24DDL

-- testcase tnz240 repartitionierung -------------------------
set current sqlid = 'S100447';
   DROP TABLESPACE  $db.aper24s1 ;
   DROP TABLESPACE  $db.aper24c1 ;
   DROP TABLESPACE  $db.aper24g1 ;
   DROP TABLESPACE  $db.aper24p1 ;
   COMMIT ;
   ;
 $@[
if $phase >= 1 then $@=[
--
  CREATE TABLESPACE aper24S1
    IN $db
    USING STOGROUP GSMS
    PRIQTY -1 SECQTY -1
    FREEPAGE 0 PCTFREE 0
    GBPCACHE CHANGED
    TRACKMOD NO
    LOGGED
    SEGSIZE 64
    BUFFERPOOL BP2
    LOCKSIZE ANY
    LOCKMAX SYSTEM
    CLOSE YES
    COMPRESS YES
    CCSID      ebcdic
    DEFINE YES
    MAXROWS 255;
--
  CREATE TABLESPACE aper24C1
    IN $db
    USING STOGROUP GSMS
    PRIQTY -1 SECQTY -1
    FREEPAGE 0 PCTFREE 0
    GBPCACHE CHANGED
    TRACKMOD NO
    LOGGED
    SEGSIZE 0
    numParts 7
    dsSize 1G
    BUFFERPOOL BP2
    LOCKSIZE ANY
    LOCKMAX SYSTEM
    CLOSE YES
    COMPRESS YES
    CCSID      ebcdic
    DEFINE YES
    MAXROWS 255;
--
  CREATE TABLESPACE aper24G1
    IN $db
    USING STOGROUP GSMS
    PRIQTY -1 SECQTY -1
    FREEPAGE 0 PCTFREE 0
    GBPCACHE CHANGED
    TRACKMOD NO
    LOGGED
    SEGSIZE 64
    maxPartitions 16
    dsSize 1G
    BUFFERPOOL BP2
    LOCKSIZE ANY
    LOCKMAX SYSTEM
    CLOSE YES
    COMPRESS YES
    CCSID      ebcdic
    DEFINE YES
    MAXROWS 255;
--
  CREATE TABLESPACE aper24P1
    IN $db
    USING STOGROUP GSMS
    PRIQTY -1 SECQTY -1
    FREEPAGE 0 PCTFREE 0
    GBPCACHE CHANGED
    TRACKMOD NO
    LOGGED
    SEGSIZE 64
    numParts 7
    dsSize 1G
    BUFFERPOOL BP2
    LOCKSIZE ANY
    LOCKMAX SYSTEM
    CLOSE YES
    COMPRESS YES
    CCSID      ebcdic
    DEFINE YES
    MAXROWS 255;
--
  CREATE TABLE $creator.tper24S1
       (part int not null
       ,key  char(20) not null
       ,text varchar(2000) not null
       )
    in $db.aper24S1
;
  CREATE INDEX $creator.iper24s1
    ON $creator.tper24S1
     (part, key)
    USING STOGROUP GSMS
    PRIQTY -1 SECQTY -1
    FREEPAGE 0 PCTFREE 10
    GBPCACHE CHANGED
    CLUSTER
    COMPRESS NO
    BUFFERPOOL BP1
;
  CREATE TABLE $creator.tper24C1
       (part int not null
       ,key  char(20) not null
       ,text varchar(2000) not null
       )
    in $db.aper24C1
    partition by (part)
      ( partition 1 ending at(100)
    $@do px=2 to 7 $@=[
      , partition $px ending at($-[100*$px$])
    $]
      )
;
  CREATE INDEX $creator.iper24c1
    ON $creator.tper24C1
     (part, key)
    partitioned
    USING STOGROUP GSMS
    PRIQTY -1 SECQTY -1
    FREEPAGE 0 PCTFREE 10
    GBPCACHE CHANGED
    CLUSTER
    COMPRESS NO
    BUFFERPOOL BP1
;
  CREATE TABLE $creator.tper24G1
       (part int not null
       ,key  char(20) not null
       ,text varchar(2000) not null
       )
    in $db.aper24G1
;
  CREATE INDEX $creator.iper24G1
    ON $creator.tper24G1
     (part, key)
    USING STOGROUP GSMS
    PRIQTY -1 SECQTY -1
    FREEPAGE 0 PCTFREE 10
    GBPCACHE CHANGED
    CLUSTER
    COMPRESS NO
    BUFFERPOOL BP1
;
  CREATE TABLE $creator.tper24P1
       (part int not null
       ,key  char(20) not null
       ,text varchar(2000) not null
       )
    in $db.aper24P1
    partition by (part)
      ( partition 1 ending at(100)
    $@do px=2 to 7 $@=[
      , partition $px ending at($-[100*$px$])
    $]
      )
;
  CREATE INDEX $creator.iper24p1
    ON $creator.tper24P1
     (part, key)
    partitioned
    USING STOGROUP GSMS
    PRIQTY -1 SECQTY -1
    FREEPAGE 0 PCTFREE 10
    GBPCACHE CHANGED
    CLUSTER
    COMPRESS NO
    BUFFERPOOL BP1
;
commit;
$]
$]