Creating and configuring a database for recording data

To record data, create a database and configure an ODBC definition to it. Configure your integration node so that it can connect to the database.

Before you begin

Read the concept topic Record and replay. For an overview of tasks that you must complete to record data, see Recording data.

About this task

You can record data to a database for audit purposes, or to help with problem determination.

A script is provided with IBM® Integration Bus that you can use to create the database and database tables. You can run this script unmodified, or you can customize it. The script creates a database called MBRECORD with a default schema. After creating the database, you create an ODBC definition to identify the data source name (DSN) for the database. You use the mqsisetdbparms command to set a user identifier and password for the integration node to use when connecting to the database. The script creates some tables that are not currently used, and are reserved for future use, such as WMB_EVENT_FIELDS and WMB_EVENT_TYPES.

You can record data to IBM DB2®, Microsoft SQL Server, and Oracle databases. For information about how to create and configure your database, see the following topics:

What to do next

Continue to follow the steps for recording data; see Recording data.