Supported databases

A broker requires access to a database to store operational and state data. You must create the database before you create the broker and specify the name of the database on the mqsicreatebroker command. The command creates tables to hold the broker data; these tables are listed in Database contents.

Multiple brokers within a single instance can access the same database, if appropriate, because the tables that are created are qualified by the broker name. Brokers in different installation locations on the same system cannot share a database.

The following table, and the accompanying notes, indicate the minimum levels of database products that are supported on each operating system.

In most environments, the broker does not have to be running on the same operating system as the database server. For details about local and remote database use, and the restrictions that apply, see Database locations.

Database support is shown below; for the latest details on all supported platforms, visit the WebSphere Event Broker Requirements Web site.

Operating system DB21 Microsoft SQL Server Oracle1+2 Sybase1
AIX Start of change

8.23
9.13+4

End of change

2000 SP3a5

9i Release 2 Patch Set 4
(9.2.0.5, patch 3501955)

10G Release 1
10G Release 2

12.5

HP-UX (Integrity platform) Start of change

8.23
9.13+4

End of change
Not applicable

10G Release 2

Not supported
HP-UX (PA-RISC platform)

8.23
9.13+4

2000 SP3a5

9i Release 2 Patch Set 4
(9.2.0.5, patch 3501955)

10G Release 1
10G Release 2

12.5

Linux (POWER platform)

8.23
9.13+4

Not applicable Not supported Not supported
Linux (x86 platform)

8.23+6
9.13+4

2000 SP3a5

9i Release 2 Patch Set 4
(9.2.0.5, patch 3501955)

10G Release 1
10G Release 2

12.5

Linux (zSeries platform)

8.23+7
9.13+4+7

Not applicable

Not supported

Not supported
Solaris (SPARC platform)

8.23+8
9.13+4

2000 SP3a5

9i Release 2 Patch Set 4
(9.2.0.5, patch 3501955)

10G Release 1
10G Release 2

12.5.3

Solaris (x86-64 platform)

8.23+8
9.13+4

Not applicable

10G Release 1

12.5.3

Windows

8.23+9
9.13+4

2000 SP3a

9i Release 2 Patch Set 4
(9.2.0.5, patch 3501955)

10G Release 110
10G Release 2

12.5

z/OS

7.111
8.111

Not applicable Not supported Not applicable
Notes:
  1. Supported releases of DB2, Oracle, and Sybase can participate as a Resource Manager in a distributed XA transaction, and can be coordinated by WebSphere MQ as the XA Transaction Manager. In WebSphere Event Broker, this support is referred to as globally coordinated message flow aupport. On z/OS, all transactions are coordinated by Recoverable Resource Services (RRS).

    If you use WebSphere MQ Version 6.0 as a transaction manager, all datasources that are connected to DB2 from message flows in both 32-bit and 64-bit execution groups must connect to 64-bit DB2 instances.

    Start of changeXA coordination with 64-bit execution groups is available only with DB2 and Oracle.End of change

  2. Start of changeBoth the Oracle Database Server and the Oracle Runtime Client are required.End of change
  3. Check the readme.html file for your product to check whether a fix pack or other fix is required.

    DB2 Version 8.2 is functionally equivalent to Version 8.1 FixPak 7. If you install DB2 Version 8.2 from the supplied CDs or DVD, you might see information that indicates the Version 8.1 level, for example when you use the command db2level.

  4. Start of changeYou must install WebSphere MQ Version 6.0.2.0 or later if you want to use DB2 Version 9.1. JDBC/XA is not supported with this database release.End of change
  5. You can use a remote SQL Server database on Windows from a Linux or UNIX system using a supplied wire protocol driver.
  6. If you have installed Linux x86 (64-bit) Red Hat Enterprise Linux AS V4.0:
    • DB2 is the only database supported on this operating system.
    • If you have installed DB2 Version 8 FixPak 9, you must use a 32-bit database instance. If you have a later release of DB2, you can use both 32-bit and 64-bit database instances.
    • XA is not supported.
  7. If you have installed Linux zSeries (64-bit) Red Hat Enterprise Linux AS V4.0, and you install a 31-bit DB2 Runtime Client, the client must be at DB2 Version 8 FixPak 10 or higher, and no other DB2 product can be installed on the same system. Therefore, the 64-bit DB2 server must be located on a separate Linux zSeries image from the one in which the broker is installed.
  8. Solaris 10 on Solaris (SPARC platform) requires DB2 Version 8 FixPak 9; Solaris 10 on Solaris (x86-64 platform) requires DB2 Version 8 FixPak 11.
  9. You can use the embedded Derby database for verification, evaluation, and test purposes only. (Derby refers to IBM Cloudscape Version 10.0, a database product that is built on the Derby database from the Apache Software Foundation.) For a production system, install and configure your chosen enterprise database.
  10. For XA coordination with Oracle 10G on Windows, you must install Patch Set 3 for Oracle 10G (10.1.0.4.0).
  11. On z/OS, DB2 is a mandatory requirement. You must create a unique database for each broker. See the Program Directory for WebSphere Event Broker for z/OS.
Related concepts
Using Derby databases on Windows
Related tasks
Finding the latest information
Creating the databases
Related reference
Database locations
Database contents
Supported processors
Operating system requirements
Additional software requirements