zOs/SQL/DB2COART

  SET CURRENT SQLID='S100447';
--
--drop   TABLESPACE db2admin.A062A;
--CREATE DATABASE DB2admin
--  BUFFERPOOL BP2
--  INDEXBP    BP1
--  CCSID      EBCDIC
--  STOGROUP   GSMS;
  commit;
  CREATE TABLESPACE A062A
    IN DB2ADMIN
    USING STOGROUP GSMS
    PRIQTY -1 SECQTY -1
    ERASE  NO
    FREEPAGE 0 PCTFREE 5
    GBPCACHE CHANGED
    TRACKMOD YES
    SEGSIZE 64
    BUFFERPOOL BP2
    LOCKSIZE ANY
    LOCKMAX SYSTEM
    CLOSE YES
    COMPRESS YES
    CCSID      EBCDIC
    DEFINE YES
    MAXROWS 255;
  COMMIT;
  CREATE TABLE OA1P.TADM62A1
     (TIMESTAMP            TIMESTAMP NOT NULL,
      STATUS               CHAR(1)   NOT NULL,
      NEWCOUNT             INTEGER   NOT NULL,
      NEWSIZE              REAL      NOT NULL,
      ALTCOUNT             INTEGER   NOT NULL,
      ALTSIZE              REAL      NOT NULL,
      OLDCOUNT             INTEGER   NOT NULL,
      OLDSIZE              REAL      NOT NULL
     )
    IN DB2ADMIN.A062A
    AUDIT NONE
    DATA CAPTURE NONE
    CCSID      EBCDIC
    NOT VOLATILE;
--
  COMMENT ON TABLE OA1P.TADM62A1 IS 'Copy Archiving Statistics';

 LABEL ON TABLE OA1P.TADM62A1 IS 'CopyArchStatistik';
 LABEL ON OA1P.TADM62A1
   ( TIMESTAMP   IS  'timestamp of run'
   , STATUS      IS  'Generiert, Erledigt'
   , NEWCOUNT    IS  'count new copies'
   , NEWSIZE     IS  'size(B) new copies'
   , ALTCOUNT    IS  'count alter copies'
   , ALTSIZE     IS  'size(B) alter copies'
   , OLDCOUNT    IS  'count old copies'
   , OLDSIZE     IS  'size(B) old copies'
   )
 ;
  COMMIT;
--
  CREATE UNIQUE INDEX OA1P.IADM62A1
    ON OA1P.TADM62A1
     (TIMESTAMP)
    USING STOGROUP GSMS
    PRIQTY -1 SECQTY -1
    ERASE  NO
    FREEPAGE 0 PCTFREE 10
    GBPCACHE CHANGED
    CLUSTER
    BUFFERPOOL BP1
    CLOSE YES
    COPY NO
    DEFINE YES
    PIECESIZE 2 G;
--
  COMMIT;
--