zOs/SQL/EXLOB

 SET CURRENT SQLID = 'S100447';


    drop   tablespace dA540769.exloblob;
    commit;
    CREATE LOB TABLESPACE EXLOBLOB
           IN DA540769
           USING STOGROUP "GSMS    "
               PRIQTY -1
               SECQTY -1
               ERASE NO
           BUFFERPOOL BP8
           DSSIZE 4G
           CLOSE YES
           LOCKMAX 0
           GBPCACHE CHANGED
           DEFINE YES
           LOGGED
           LOCKSIZE LOB;



    CREATE TABLESPACE EXLOBNTR
           IN DA540769
           USING STOGROUP "GSMS    "
               PRIQTY -1
               SECQTY -1
               ERASE NO
           BUFFERPOOL BP2
           CLOSE NO
           LOCKMAX SYSTEM
           SEGSIZE 32
           FREEPAGE 5
           PCTFREE 20
           GBPCACHE CHANGED
           DEFINE YES
           LOGGED
           TRACKMOD YES
           COMPRESS NO
           LOCKSIZE ANY
           MAXROWS 255
           CCSID EBCDIC;


    CREATE TABLE A540769.EXLOBNTRIES
        (BROKERUUID CHARACTER(16) FOR BIT DATA
                                                        NOT NULL
        ,ACCESSID CHARACTER(60) FOR BIT DATA
                                                        NOT NULL
        ,QOPLEVEL CHARACTER(2) FOR BIT DATA
  WITH DEFAULT NULL
        ,PERMISSIONS INTEGER
  WITH DEFAULT NULL
        ,EXLOBNTRIES_ROWID ROWID
                                                        NOT NULL
  GENERATED ALWAYS
        ,TOPIC BLOB(1G)
  WITH DEFAULT NULL
        ,PRINCIPAL VARCHAR(128) FOR BIT DATA
                                                        NOT NULL
        ,CONSTRAINT BROKERUUID PRIMARY KEY
        (BROKERUUID
        ,ACCESSID
        )
        )
        IN DA540769.EXLOBNTR
   APPEND NO
   NOT VOLATILE CARDINALITY
   DATA CAPTURE NONE
   AUDIT NONE
   CCSID EBCDIC;


    CREATE        UNIQUE INDEX A540769.EXLOBNTRIES
           ON A540769.EXLOBNTRIES
          (BROKERUUID ASC
          ,ACCESSID ASC
          )
           CLUSTER
           DEFINE YES
           COMPRESS NO
           BUFFERPOOL BP1
           CLOSE NO
           DEFER NO
           COPY NO
           USING STOGROUP "GSMS    "
               PRIQTY -1
               SECQTY -1
               ERASE NO
           FREEPAGE 5
           PCTFREE 30
           GBPCACHE CHANGED
           PIECESIZE 2097152K;

    CREATE AUXILIARY TABLE A540769.EXLOBNTRIES_LOBAUX
        IN DA540769.EXLOBLOB
        STORES A540769.EXLOBNTRIES
        APPEND NO
        COLUMN TOPIC;


    CREATE        UNIQUE INDEX A540769.EXLOBNTRIES_LOB_I2
           ON A540769.EXLOBNTRIES_LOBAUX
           PADDED
           DEFINE YES
           COMPRESS NO
           BUFFERPOOL BP1
           CLOSE YES
           COPY NO
           USING STOGROUP "GSMS    "
               PRIQTY -1
               SECQTY -1
               ERASE NO
           FREEPAGE 0
           PCTFREE 10
           GBPCACHE CHANGED
           PIECESIZE 4194304K;