zOs/TX/PBGUTDDL

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

CREATE TABLESPACE apbguta
    IN $db
    USING STOGROUP GSMS
    PRIQTY -1 SECQTY -1
    GBPCACHE CHANGED
    TRACKMOD NO
    LOGGED
    BUFFERPOOL BP2
    LOCKSIZE ANY
    LOCKMAX SYSTEM
    CLOSE YES
    COMPRESS YES
    CCSID      ebcdic
    DEFINE YES
    SEGSIZE 64
    maxpartitions 100   -- uts PBG partitioned by growth
    dssize 1  G
    MAXROWS 255
    FREEPAGE 0
;
CREATE TABLE $creator.tqz91pbgUtA
    ( i1 integer not null generated always as identity
    , c2 varchar(4000) not null with default
    )
    in $db.apbguta;
CREATE INDEX $creator.IpbgUtA1
           ON $creator.tqz91pbgUtA
          (i1 asc
          )
           CLUSTER
           DEFINE YES
           COMPRESS NO
           BUFFERPOOL BP1
           CLOSE YES
           DEFER NO
           COPY NO
           USING STOGROUP "GSMS    "
               PRIQTY -1
               SECQTY -1
               ERASE NO
           PIECESIZE 8M
           FREEPAGE 0
           PCTFREE 0
           GBPCACHE CHANGED
;
insert into $creator.tqz91pbgUtA (c2)
     select char(current timestamp)
          || repeat(left(' ' || strip(creator) || '.' || strip(name)
                          || ' in ' || strip(dbName) || '.' || tsname
                     , 50), 70)
       from sysibm.sysTables
;
commit
;