Start of change

Enabling connections to the databases

The broker uses ODBC to connect to databases. You must, therefore, define ODBC data source names (DSNs) for the broker database on each system that hosts a broker. At any one time there can be multiple connections using the same DSN definition.

z/OS platform On z/OS systems, see Data sources on z/OS for information about enabling connections to databases.

Linux platform On Linux (zSeries platform) and Linux (POWER platform), the only supported database manager is DB2; the broker connect to the databases directly using the DB2 supplied driver and do not use a driver manager. The DB2 alias is used as the DSN.

On distributed systems, when defining the DSNs, there are two important considerations that determine whether you must define a 32-bit DSN for the database, a 64-bit DSN, or both:
  • Whether the execution group and the database are 32-bit or 64-bit
  • Whether or not the message flow transactions will be globally coordinated

Start of changeFor more information about the 32-bit and 64-bit considerations, see Broker database connections End of change

When you have defined the appropriate DSNs, you must also configure the environment so that the broker can access the correct database libraries (see Setting your environment to access databases).

To enable connections on distributed systems:

  1. Define the ODBC DSNs according to your platform:
    On Windows:
    Follow the instructions in Connecting to a database from Windows.
    On Linux (x86 platform):
    Follow the instructions in Connecting to a database from Linux and UNIX systems.
    On UNIX systems:
    Depending on your broker configuration, for each database you might need to define a 32-bit ODBC DSN, a 64-bit ODBC DSN, or both.
    Refer to the following table to check which DSNs you must define. For more information about 32-bit and 64-bit considerations, see Broker database connections .
    Table 1. Enabling connections to databases.
      32-bit execution group 64-bit execution group

    32-bit broker

    Broker database: 32-bit

    Broker database: 32-bit and 64-bit

    64-bit broker

    (HP-UX (Itanium platform) only)

    Not possible.

    Broker database: 64-bit

    You have now configured the ODBC DSN for your broker database.
  2. Configure the environment for issuing console commands and for running the broker so that it can access the required database libraries. For more information, see Setting your environment to access databases.
You have now enabled the broker to make connections to the broker database.
Next, return to the instructions in Configuring databases.
Related tasks
Configuring databases
Related reference
Supported databases
odbc.ini sample file
odbc64.ini sample file
End of change