zOs/TX/PER11DDL

------------$-{right(userid() sysvar(sysnode) date(s) time(), 60, '-')}
-- testCase $dsn
-- env      $env      phase $phase
-- subsys   $subsys     db $db       creator $creator
------------------------------------------------------------------------
---||| begin ddl testcase $mbr env $env phase $phase
$=cr2=$creator
SET CURRENT SQLID='S100447';
drop tablespace $db.aPer11;
-- drop table     $creator.tPer11;
commit;
------------------------------------------------------------------------
CREATE TABLESPACE aPer11
    IN $db
    USING STOGROUP GSMS
    PRIQTY -1 SECQTY -1
    ERASE  NO
    FREEPAGE 0 PCTFREE 10
    GBPCACHE CHANGED
    TRACKMOD YES
    SEGSIZE  64
    BUFFERPOOL BP32K
    LOCKMAX SYSTEM
    CLOSE YES
    COMPRESS YES
    CCSID      EBCDIC
    DEFINE YES
    locksize row
    MAXROWS 255
;
commit;
  CREATE TABLE $creator.tPer11
  ( cnt         int not null
  , s1Rows      int not null
  , s1RowF      int not null
  , s1RowT      int not null
  , vrRows      real not null
  , vrRowF      int not null
  , vrRowT      int not null
  , buRows      real not null
  , buRowF      int not null
  , buRowT      int not null
  , type    char(20) not null
  ) in $db.aPer11;
--------------------------------------------------------------
commit;
--insert into $creator.tPer11 values
--    (1, char(current timestamp) || ' initial eins');
  commit;
---||| end   ddl testcase $mbr env $env phase $phase