coreDBUtility를 사용하여 z/OS®의 원격 DB2® 메시지 로거 데이터베이스에서 테이블을 작성하기 위한 스크립트를 생성할 수 있습니다. 여기서, 이 스크립트의 예를 확인할 수 있습니다.
-- @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;