Messages processed by mediation modules can be logged in the enterprise service bus logger mediation database (EsbLogMedDB).
The enterprise service bus logger mediation (EsbLogMedDB) database is used by the MessageLogger mediation primitive in WebSphere Process Server. It is created automatically for a stand-alone profile. A set of DDL files are provided to allow you to use additional databases either in a stand-alone profile or for a network deployment environment.
A Cloudscape™ 5.1 database is created automatically during stand-alone profile creation. Users can manually create databases for all the other supported database types, using the appropriate DDL file. The DDL file is called Table.ddl and is found in the install_root/util/EsbLoggerMediation/dbType directory. The same file can be used to create the EsbLogMedDB for a network deployment environment.
Only one DBMS instance is automatically created for a stand-alone profile; however, users can manually create as many other instances as they require (each message logger mediation primitive can be configured to use a different data source and hence a different database).
Deployment manager profile
Manually create the database using the file Table.ddl.
The file createMessageLoggerResource.jacl is located in install_root/bin and is used during the stand-alone profile creation. DDL files for all database types are located in the install_root/util/EsbLoggerMediation/dbType directories.
If a suitable JDBC provider is obtained at server scope, then this is used. The name of the data source is "ESB Logger Mediation Data Source". You can create your own data source to use if you wish to configure a Message Logger mediation primitive to use a different data source.
A Cloudscape 5.1 database is created in a stand-alone profile. No automatic creation is performed for network deployment. The Message Logger mediation primitive assumes a fixed table name of MSGLOG and a fixed schema qualifier of ESBLOG.
Only one table is created called MSGLOG.
No enterprise service bus Logger mediation database scripts are exported during profile creation.
The user credentials that you provide to the Profile wizard should have the permissions to be able to create tablespaces, tables, indexes, and stored procedures.
Last updated: Wed 01 Nov 2006 07:47:12
(c) Copyright IBM Corporation 2005, 2006.
This information center is powered by Eclipse technology (http://www.eclipse.org)