Creating and configuring a database for recording data

A script is provided with IBM® App Connect Enterprise 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 mqsicredentials command to set a user identifier and password for the integration server to use when connecting to the database. Alternatively, you can use the mqsisetdbparms command. 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.