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 | ![]() 8.23 ![]() |
2000 SP3a5 |
9i Release 2 Patch Set 4 |
12.5 |
HP-UX (Integrity platform) | ![]() 8.23 ![]() |
Not applicable | 10G Release 2 |
Not supported |
HP-UX (PA-RISC platform) | 8.23 |
2000 SP3a5 |
9i Release 2 Patch Set 4 |
12.5 |
Linux (POWER platform) | 8.23 |
Not applicable | Not supported | Not supported |
Linux (x86 platform) | 8.23+6 |
2000 SP3a5 |
9i Release 2 Patch Set 4 |
12.5 |
Linux (zSeries platform) | 8.23+7 |
Not applicable | Not supported |
Not supported |
Solaris (SPARC platform) | 8.23+8 |
2000 SP3a5 |
9i Release 2 Patch Set 4 |
12.5.3 |
Solaris (x86-64 platform) | 8.23+8 |
Not applicable | 10G Release 1 |
12.5.3 |
Windows | 8.23+9 |
2000 SP3a |
9i Release 2 Patch Set 4 |
12.5 |
z/OS | 7.111 |
Not applicable | Not supported | Not applicable |
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.
XA
coordination with 64-bit execution groups is available only with DB2 and Oracle.
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.
Notices |
Trademarks |
Downloads |
Library |
Support |
Feedback
![]() ![]() |
ah10030_ |