zOs/TX/PER09DDL

  SET CURRENT SQLID='S100447';
  drop tablespace  $db.APER09;
  commit;
$@[
if $phase >= 1 then $@=[
  CREATE TABLESPACE APER09
    IN $db
    USING STOGROUP GSMS
    PRIQTY -1 SECQTY -1
    FREEPAGE 10 PCTFREE $phase
    GBPCACHE CHANGED
    TRACKMOD YES
    NUMPARTS $prts
    BUFFERPOOL BP2
    LOCKSIZE ANY
    LOCKMAX SYSTEM
    CLOSE YES
    COMPRESS YES
    CCSID      EBCDIC
    DEFINE NO
    MAXROWS 255;
  COMMIT;

  CREATE TABLE $creator.TPer09
     (part                 int NOT NULL,
      tst                  timestamp not null with default,
      text                 varChar(2000) not null with default
     )
     PARTITION BY (part)
      (PART 1 VALUES(1)
     $@do px=2 to $prts $@=[
      ,PART $px VALUES($px)
         $]
      )
    IN $db.APer09
    AUDIT NONE
    DATA CAPTURE NONE
    CCSID      EBCDIC
    NOT VOLATILE;
  COMMIT;
  CREATE INDEX $creator.IPer09A0
    ON $creator.TPer09
     (tst                   ASC)
    USING STOGROUP GSMS
    PRIQTY -1 SECQTY -1
    FREEPAGE 10 PCTFREE 10
    GBPCACHE CHANGED
    CLUSTER
    Partitioned
    BUFFERPOOL BP1
    CLOSE YES
    COPY NO
    DEFER NO
    DEFINE NO ;
  COMMIT;
$]
$]