WebSphere Message Broker, Version 8.0.0.7 Operating Systems: AIX, HP-Itanium, Linux, Solaris, Windows, z/OS

See information about the latest product version

Creating and configuring an Oracle database for recording data

To record data to an Oracle database, create the database tables and configure an ODBC definition. Configure your broker so that it can connect to the database.

  1. Use the script that is provided with WebSphere® Message Broker to create and configure the Oracle database tables in the default table space, which is where your recorded data will be stored.
    1. Locate the script for your operating system:
      • Windows: install_dir\ddl\oracle\DataCaptureSchema.sql
      • UNIX: install_dir/ddl/oracle/DataCaptureSchema.sql
      install_dir is the location of your WebSphere Message Broker installation.
    2. On Oracle, enter the following command to run the script:
      sqlplus user/password @DataCaptureSchema.sql
  2. Create an ODBC definition for the database.

    If you used the supplied script to create your database without modifications, create an ODBC definition for the database called MBRECORD, with MBRECORD as the data source name (DSN). For more information, see Enabling ODBC connections to the databases.

  3. Use the mqsisetdbparms command to set a user identifier and password for the broker to use when connecting to the database; for example:
    mqsisetdbparms brokerName -n dataSourceName -u userID -p password
    • brokerName is the name of your broker
    • dataSourceName identifies the database to which you want to record data
    • userID and password specify the user identifier and the password that the broker uses to connect to the database
  4. To ensure that the changes to the mqsisetdbparms command take effect, restart the broker. For more information, see Starting and stopping a broker.
  5. Test the connection to your database by using the mqsicvp command. For more information, see mqsicvp command.

Next:

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

Notices | Trademarks | Downloads | Library | Support | Feedback

Copyright IBM Corporation 1999, 2016Copyright IBM Corporation 1999, 2016.

        
        Last updated:
        
        Last updated: 2016-05-23 14:48:15


Task topicTask topic | Version 8.0.0.7 | bj28420_