zOs/SQL/ABUBDDLT

set current sqlid = 'S100447';
xrop  tablespace qz01a1p.a045a ;
xrop  tablespace qz01a1p.a046a ;
commit;
CREATE TABLESPACE a045a
  IN qz01a1p
  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
;
CREATE TABLESPACE a046a
  IN qz01a1p
  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
;
CREATE TABLE oa1p.tQZ045AbUbEvent
  ( ab         CHAR(8) NOT NULL
  , rz         CHAR(3) NOT NULL
  , dbSy       char(4) NOT NULL
  , tst        timestamp(0) not null
  , event      char(4) NOT NULL
  , orTst      timestamp(0) not null  default '0001-01-01-00.00.00'
  , link       char(60) NOT NULL default
  , cont       varchar(500) not null default
  )
 in qz01a1p.a045a
;
CREATE UNIQUE INDEX oa1p.iQZ045A1
  ON oa1p.tQZ045AbUbEvent
   (ab, rz, dbSy, tst)
   include (event)
  USING STOGROUP GSMS
  ERASE  NO
  GBPCACHE CHANGED
  not CLUSTER
  BUFFERPOOL BP1
  CLOSE YES
  COPY NO
  DEFINE YES
  PIECESIZE 2 G
;
CREATE TABLE oa1p.tQZ046AbUbRule
  ( rule       char(8) not null
  , type       char(8) not null
  , subType    char(8) not null
  , va1        char(16) not null
  , va2        char(16) not null
  , va3        char(60) not null with default
  , va4        char(200) not null with default
  )
 in qz01a1p.a046a
;
CREATE        INDEX oa1p.iQZ046A1
  ON oa1p.tQZ046AbUbRule
   (rule, type, subType, va1, va2)
  USING STOGROUP GSMS
  ERASE  NO
  GBPCACHE CHANGED
  not CLUSTER
  BUFFERPOOL BP1
  CLOSE YES
  COPY NO
  DEFINE YES
  PIECESIZE 2 G
;