Use the enterprise service bus logger mediation database specifications for locating information about supported database types; script names and their locations; profile creation configuration actions; schema upgrades and user ID privileges.
The enterprise service bus logger mediation database is used by the MessageLogger mediation primitive in WebSphere® ESB. The Message Logger primitives stores message information in the Common database. The Common database is the default for the enterprise service bus logger mediation database, but you can use an external database. During the profile augmentation phase, the system creates a variable called ESB_MESSAGE_LOGGER_QUALIFIER which is set to the value of the chosen Common database schema qualifier.
The database is created automatically for a stand-alone configuration. A set of DDL files are provided to allow you to use additional databases either in a stand-alone server configuration or for a network deployment environment.
For a stand-alone configuration using a DB2® for z/OS® database, or for a managed node or deployment manager in a Network Deployment configuration, you must create the Enterprise Service Bus database and storage groups before running the WebSphere Process Server for z/OS configuration script.
Database Types | Considerations |
---|---|
Derby Embedded | Used as the default database type for standalone profile. |
Derby Network Server | Used as the default database type in network deployment environment. |
DB2 Universal | Used as the database in network deployment configurations. Optionally, can be used as the database in stand-alone server configurations. |
DB2 for z/OS v8 |
Important: When creating a profile
for a server that uses DB2 for z/OS v9,
the server must be able to connect to the DB2 database.
Used
as the database in network deployment configurations. Optionally,
can be used as the database in stand-alone server configurations. |
DB2 UDB for iSeries (Native) |
Used as a local database for standalone profile. |
DB2 UDB for iSeries (Toolbox) |
Used as a remote database for network deployment environment or as a local database for a standalone profile.Used as the database in network deployment configurations. Optionally, can be used as the database in stand-alone server configurations. |
DB2 Universal Runtime Client | Used as the database in network deployment configurations. Optionally, can be used as the database in stand-alone server configurations. |
Informix Dynamic Server | |
Microsoft SQL Server (Embedded) | |
Microsoft SQL Server (DataDirect) | |
Microsoft SQL Server (Microsoft) - Support for the Microsoft SQL Server JDBC Driver, version 1.2 was added in WebSphere Process Server, version 6.2.0.1 | |
Oracle 9i |
You need sysdba privilege to create the database, tables and schemas. Failure to have the correct sysdba privilege can result in errors creating and accessing the tables and schemas. |
The Common database is used for both the standalone and network deployment environments at cell scope. 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).
For the standalone and deployment manager profiles the enterprise service bus logger profile will execute the Common database script createTable in the Common database. See the"Common database specifications" for more information.
Stand-alone profile
In a default stand-alone environment a Derby database is automatically created named EsbLogMedDB.
Network deployment environment
The default enterprise service bus database is not automatically selected during network deployment profile creation. You must chose either the default database or one of the supported databases.
The SQL script createTable_ESB.sql is located in install_root/dbscripts/CommonDB/DBTYPE.
The scripts createMessageLoggerResource.jacl and removeMessageLoggerResource.jacl are located in install_root/bin and can be used to create or delete tables in the requested database type.
The Common database JDBC provider and data source are used by default:
You can create your own data source configuring the Message Logger mediation to use a different data source.
There are no known restrictions.
The enterprise service bus logger mediation database uses the MSGLOG table in the Common database. You can choose not to use the Common database, and you can use an external database if desired.
The database scripts are exported to the following location: install_root/dbscripts/CommonDB/DBTYPE/dbName
No schema upgrade involved for MSGLOG table. When you migrate to WebSphere ESB version 6.1, WebSphere ESB continues to use the MessageLogger databases used in prior releases. There is no support to migrate this data into the WebSphere ESB Common database.