É possível utilizar o coreDBUtility para gerar um script para criar tabelas em um banco de dados criador de logs de mensagens remoto do DB2 no z/OS. Um exemplo desse script pode ser visto aqui.
-- @start_restricted_prolog@ -- Licensed Materials - Property of IBM -- 5724-I82 5724-L01 5655-N63 5655-R15 -- (C) Copyright IBM Corporation 2006 All Rights Reserved. -- US Government Users Restricted Rights- Use, duplication or disclosure -- restricted by GSA ADP Schedule Contract with IBM Corp. -- @end_restricted_prolog@ -- DB2UDB for z/OS V8.1 schema for Message Logger Mediation -- ESBDB DBName -- ESBDBSTO StorageGroup -- ESBLOG SQLID -- Create Tablespaces CREATE TABLESPACE ESBTS LOCKSIZE ROW CCSID UNICODE BUFFERPOOL BP0 IN ESBDB USING STOGROUP ESBDBSTO; CREATE LOB TABLESPACE ESBCLOB IN ESBDB USING STOGROUP ESBDBSTO; -- Create Tables CREATE TABLE ESBLOG.MSGLOG (TIMESTAMP TIMESTAMP NOT NULL, MESSAGEID VARCHAR(36) NOT NULL, MEDIATIONNAME VARCHAR(256) NOT NULL, MODULENAME VARCHAR(256), MESSAGE CLOB(100000K), VERSION VARCHAR(10), CONSTRAINT PK_MSGLOG PRIMARY KEY (MESSAGEID, TIMESTAMP, MEDIATIONNAME)) IN ESBDB.ESBTS; CREATE UNIQUE INDEX ESBLOG.MSGLOG_INDEX_PK ON ESBLOG.MSGLOG (MESSAGEID, TIMESTAMP, MEDIATIONNAME) USING STOGROUP ESBDBSTO; -- Create AUX CLOB Tables/Index CREATE AUX TABLE ESBLOG.MESSAGECLOB IN ESBDB.ESBCLOB STORES ESBLOG.MSGLOG COLUMN MESSAGE; CREATE INDEX ESBLOG.MESSAGECLOB_IDX ON ESBLOG.MESSAGECLOB USING STOGROUP ESBDBSTO;