zOs/TX/WK960DDL

------------$-[right(userid() sysvar(sysnode) date(s) time(), 60, '-')$]
-- testCase $dsn
-- env      $env      phase $phase
-- dbSys    $dbSys      db $db       creator $creator
------------------------------------------------------------------------
---||| begin ddl testcase $mbr env $env phase $phase
SET CURRENT SQLID='S100447';
drop tablespace $db.awk960;
commit;
------------------------------------------------------------------------
CREATE TABLESPACE aWK960
    IN $db
    USING STOGROUP GSMS
    PRIQTY -1 SECQTY -1
    ERASE  NO
    FREEPAGE 0 PCTFREE 10
    GBPCACHE CHANGED
    TRACKMOD YES
    segsize 64
    BUFFERPOOL BP2
    LOCKSIZE ANY
    LOCKMAX SYSTEM
    CLOSE YES
    COMPRESS YES
    CCSID      unicode
    DEFINE YES
    MAXROWS 255
;  ---------------------------------------------------------------------
--- set current isolation level = 'UR';
  CREATE TABLE $creator.tqz91wk960
     (
       c char(10) not null
     , d timestamp not null with default
     )
    IN $db.aWK960
    AUDIT NONE
    DATA CAPTURE NONE
    CCSID      unicode
    NOT VOLATILE ;
$@ if $phase = 1 | $phase >= 3 then $@=[
  CREATE UNIQUE INDEX $creator.Iqz91wk960A1
    ON $creator.Tqz91wk960
     (c             ASC)
      $-[copies(cluster, $phase // 2 = 1)$]
      CLOSE YES
    USING STOGROUP GSMS
    PRIQTY -1 SECQTY -1
    ERASE  NO
    FREEPAGE 0 PCTFREE 10
    GBPCACHE CHANGED
    BUFFERPOOL BP1
    COPY NO
    DEFER NO
    DEFINE YES;
$]
$@ if $phase = 2 | $phase >= 3 then $@=[
  CREATE UNIQUE INDEX $creator.Iqz91wk960A2
    ON $creator.Tqz91wk960
    $@ if $phase < 8 then
     (d            desc)
    $@ else
     (d asc, c desc)
      $-[copies(cluster, $phase // 2 = 0)$]
      CLOSE YES
    USING STOGROUP GSMS
    PRIQTY -1 SECQTY -1
    ERASE  NO
    FREEPAGE 0 PCTFREE 10
    GBPCACHE CHANGED
    BUFFERPOOL BP1
    COPY NO
    DEFER NO
    DEFINE YES;
$]
--
  COMMIT;
insert into $creator.tqz91wk960(c) values ('eins');
insert into $creator.tqz91wk960(c) values ('zwei');
insert into $creator.tqz91wk960(c) values ('drei');
insert into $creator.tqz91wk960(c) values ('vier');
insert into $creator.tqz91wk960(c) values ('fuenf');
commit;
---||| end   ddl testcase $mbr env $env phase $phase