WebSphere Enterprise Service Bus, Version 6.2.0 Operating Systems: AIX, HP-UX, i5/OS, Linux, Solaris, Windows


Example of Table_esb_DB2UDBOS390_V8_1.ddl

You can use coreDBUtility to generate a script for creating tables in a remote DB2® message logger database on z/OS®. You can see an example of this script here.

-- @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;

reference Reference topic

Terms of use | Feedback


Timestamp icon Last updated: 21 June 2010


http://publib.boulder.ibm.com/infocenter/dmndhelp/v6r2mx/topic//com.ibm.websphere.wesb620.doc/doc/rins_table_esb.html
Copyright IBM Corporation 2005, 2010. All Rights Reserved.
This information center is powered by Eclipse technology (http://www.eclipse.org).