zOs/SQL/CREPART

 DROP TABLESPACE             DGDB0211.A155A;
 COMMIT;

 CREATE TABLESPACE           A155A
 IN                          DGDB0211
 USING STOGROUP              GSMS
 PRIQTY                      72
 SECQTY                      720000
 ERASE                       NO
 FREEPAGE                    0
 PCTFREE                     15
 COMPRESS                    YES
 DSSIZE                      4 G
 NUMPARTS                    12
 BUFFERPOOL                  BP2
 LOCKSIZE                    ANY
 LOCKMAX                     SYSTEM
 CLOSE                       YES
 -- SEGSIZE                     64
 ;

 COMMIT;

 CREATE TABLE                DGDB0211.TID155A1
 (                           TID155MON         SMALLINT     NOT NULL,
                             TID155TST         TIMESTAMP    NOT NULL,
                             TID155UUI         CHAR(35)     NOT NULL,
                             TID155CHA         CHAR(3)      NOT NULL,
                             TID155LNR         CHAR(4)      NOT NULL,
                             TID155VRS         CHAR(4)      NOT NULL,
                             TID155CRE         CHAR(7)      NOT NULL,
                             TID155IDT         CHAR(2)      NOT NULL,
                             TID155IDE         CHAR(20)     NOT NULL,
                             TID155ADT         CHAR(2)      NOT NULL,
                             TID155ADR         CHAR(40)     NOT NULL,
                             TID155BU          CHAR(4)      NOT NULL,
                             TID155BKS         CHAR(4)      NOT NULL,
                             TID155ARE         CHAR(4)      NOT NULL,
                             TID155CBE         CHAR(8)      NOT NULL,
                             TID155INS         CHAR(8)      NOT NULL
 )
 IN                          DGDB0211.A155A
 ;

 CREATE TYPE 2 INDEX  DGDB0211.IID155A1
 ON                          DGDB0211.TID155A1
                            (TID155MON,
                             TID155TST )
 USING STOGROUP              GSMS
 PRIQTY                      72
 SECQTY                      72000
 ERASE                       NO
 FREEPAGE                    0
 PCTFREE                     15
 GBPCACHE                    ALL
 CLUSTER
     (
         PART 1 VALUES ( 1 ) ,
         PART 2 VALUES ( 2 ) ,
         PART 3 VALUES ( 3 ) ,
         PART 4 VALUES ( 4 ) ,
         PART 5 VALUES ( 5 ) ,
         PART 6 VALUES ( 6 ) ,
         PART 7 VALUES ( 7 ) ,
         PART 8 VALUES ( 8 ) ,
         PART 9 VALUES ( 9 ) ,
         PART 10 VALUES(10 ) ,
         PART 11 VALUES(11 ) ,
         PART 12 VALUES(12 )
     )
 BUFFERPOOL                  BP1
 CLOSE                       YES;

 CREATE TYPE 2 INDEX  DGDB0211.IID155A2
 ON                          DGDB0211.TID155A1
                            (TID155UUI)
 USING STOGROUP              GSMS
 PRIQTY                      72
 SECQTY                      72000
 ERASE                       NO
 FREEPAGE                    0
 PCTFREE                     15
 GBPCACHE                    ALL
 BUFFERPOOL                  BP1
 CLOSE                       YES;

 LABEL ON TABLE              DGDB0211.TID155A1
 IS                         'UUID Log';

 LABEL ON COLUMN             DGDB0211.TID155A1.TID155MON
 IS                         'Monat';

 LABEL ON COLUMN             DGDB0211.TID155A1.TID155TST
 IS                         'curr Timestampe';

 LABEL ON COLUMN             DGDB0211.TID155A1.TID155UUI
 IS                         'UUID';

 LABEL ON COLUMN             DGDB0211.TID155A1.TID155CHA
 IS                         'curr. Channel';

 LABEL ON COLUMN             DGDB0211.TID155A1.TID155LNR
 IS                         'Listen Nr. POV';

 LABEL ON COLUMN             DGDB0211.TID155A1.TID155VRS
 IS                         'Versions Nummer POV';

 LABEL ON COLUMN             DGDB0211.TID155A1.TID155CRE
 IS                         'Creation Date POV';

 LABEL ON COLUMN             DGDB0211.TID155A1.TID155IDT
 IS                         'Empfänger Identifikation Typ';

 LABEL ON COLUMN             DGDB0211.TID155A1.TID155IDE
 IS                         'Empfänger Identifikation';

 LABEL ON COLUMN             DGDB0211.TID155A1.TID155ADT
 IS                         'Empfänger Adresse Typ';

 LABEL ON COLUMN             DGDB0211.TID155A1.TID155ADR
 IS                         'Empfänger Adresse';

 LABEL ON COLUMN             DGDB0211.TID155A1.TID155BU
 IS                         'Business ID';

 LABEL ON COLUMN             DGDB0211.TID155A1.TID155BKS
 IS                         'Bankstelle';

 LABEL ON COLUMN             DGDB0211.TID155A1.TID155ARE
 IS                         'ARES Code';

 LABEL ON COLUMN             DGDB0211.TID155A1.TID155CBE
 IS                         'Mailt Betr';

 LABEL ON COLUMN             DGDB0211.TID155A1.TID155INS
 IS                         'Instradierung';

 COMMIT;