zOs/TX/TSALTDDL

set current sqlid = 'S100447';
DROP TABLESPACE  $db.atsAlt  ;
COMMIT ;

$@ if $phase >= 1 then $@=/p1/
CREATE TABLESPACE aTsAlt
    IN $db
    USING STOGROUP GSMS
    PRIQTY -1 SECQTY -1
    GBPCACHE CHANGED
    TRACKMOD NO
    LOGGED
$@ if ($phase // 10) = 1 then
    BUFFERPOOL BP1
$@ else if ($phase // 10) = 3 then
    BUFFERPOOL BP32K
$@ else
    BUFFERPOOL BP2
    LOCKSIZE ANY
    LOCKMAX SYSTEM
    CLOSE YES
    COMPRESS YES
    CCSID      ebcdic
    DEFINE YES
$@ if ($phase % 20 // 2) = 0 then
    SEGSIZE 64   -- segmented
$@ else
    SEGSIZE  8   -- segmented
    maxPartitions 1
$@ if ($phase % 10 // 2) = 0 then
    dssize 16 g
$@ else
    dssize  4 g
    MAXROWS 255
           FREEPAGE 0
;
CREATE TABLE $creator.tqztsAlt
    ( c1 char(15) not null with default
    , c2 char(10) not null with default
    , c3 char(10) not null with default
    , c4 char(10) not null with default
    )
        IN $db.atsAlt
   CCSID         EBCDIC
;
CREATE UNIQUE INDEX $creator.ItsAltA1
           ON $creator.tQZtsAlt
          (c1 asc
          ,c2 asc
          )
           CLUSTER
           DEFINE YES
           COMPRESS NO
           BUFFERPOOL BP1
           CLOSE YES
           DEFER NO
           COPY NO
           USING STOGROUP "GSMS    "
               PRIQTY -1
               SECQTY -1
               ERASE NO
           FREEPAGE 0
           PCTFREE 0
           GBPCACHE CHANGED
;
insert into $creator.tQZTsAlt (c1, c2) values('eins', 'eins 1');
insert into $creator.tQZTsAlt  (c1, c2) values('zwei', 'zwei 2');
insert into $creator.tQZTsAlt  (c1, c2) values('drei', 'drei 3');
insert into $creator.tQZTsAlt  (c1, c2) values('vier', 'vier 4');
insert into $creator.tQZTsAlt  (c1, c2) values('fuenf', 'fuenf 5');
insert into $creator.tQZTsAlt  (c1, c2) values('sechs', 'sechs 6');
commit;
$/p1/