Configuring a messaging engine to use a data source

After setting up a data store and configuring its data source, you can configure a messaging engine to use the data source.

Before you begin

You must have already set up a data store and configured a data source. For more information, refer to Setting up the data store for a messaging engine.

About this task

A messaging engine uses an instance of a JDBC data source to interact with the database that contains the data store for that messaging engine.

Use the WebSphere® Application Server administrative console to set the data store configuration parameters.

Perform the following steps to configure the messaging engine to use a data source using the administrative console:

Procedure

  1. In the navigation pane, click Service Integration > Buses.
  2. In the content pane, click the name of the bus to which your messaging engine belongs.
  3. Under Topology, click Messaging engines. A list of messaging engines is displayed.
  4. Click the messaging engine name.
  5. On the Configuration pane, find the Message store type option, which is Data store.
  6. Click on the Configure button.
  7. On a new page, specify the following properties:
    Data source name
    Type the JNDI name of the data source that provides access to database that holds the data store.
    Schema name
    Type the name of the database schema that contains the tables used by the data store.
    General tip: The schema name is usually the same as the user ID that is declared in the authentication alias. With some databases, for example DB2®, you can provide an alternative schema name. For more information about the relationship between users and schema, refer to the documentation for your chosen RDBMS.
    Informix tip: When you configure your messaging engine to use an Informix® database, you must specify the schema name in lower case.

    When starting, a messaging engine that uses a data store checks to see if its data store exists. If the user has selected the Create tables option in the configuration, whose tick-box is ticked by default, the messaging engine creates the tables in its chosen schema.

    The Schema name field is optional, and:
    • The default schema name is IBMWSSIB.
    • If you delete the text so that field is blank, the messaging engine takes the user id defined in the authentication alias to be the schema name.
    • If you define a schema name explicitly, that schema name is used by the messaging engine.
    Authentication alias
    Select the authentication alias that enables access to the data source.
    Cloudscape (Derby) Tip: When you create a new Network Attached Cloudscape Version 10.1.x (Derby) data store, by default you get a blank authentication alias.
    Create tables
    Select the check box if you want WebSphere Application Server to create the database tables automatically. For more information, refer to Creating the tables.
    Note: The user ID that the data store uses to connect to the data source must have sufficient authority to create the database tables and indexes.
    DB2 for z/OS restriction: The option for WebSphere Application Server to create the tables is not available with DB2 for z/OS®. Refer to Enabling your database administrator to create the data store tables if you use DB2 for z/OS.
    Number of permanent tables
    Permanent table contains persistent objects for the data store.
    Note: You can only increase the number of permanent tables or temporary tables, not decrease them.
    See related links for more information.
    Number of temporary tables
    Temporary tables nonpersistent objects that have been saved to the data store to reduce the messaging engine memory requirement.
    Note: You can only increase the number of permanent tables or temporary tables, not decrease them.
    See related links for more information.



In this information ...


IBM Redbooks, demos, education, and more

(Index)

Use IBM Suggests to retrieve related content from ibm.com and beyond, identified for your convenience.

This feature requires Internet access.

Task topic Task topic    

Terms and conditions for information centers | Feedback

Last updatedLast updated: Aug 30, 2013 6:03:36 PM CDT
http://www14.software.ibm.com/webapp/wsbroker/redirect?version=pix&product=was-base-iseries&topic=tjm0045
File name: tjm0045_.html