A broker requires access to a database to store operational and state data. Databases from IBM and other suppliers are supported at specific versions on supported operating systems.
You must create the broker 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.
You can use the same database schema for all brokers that
are at the same version, if appropriate, even if you create the brokers
on different computers. The broker tables are created in a schema
that is determined by the user ID that you specify for the broker
database connection, and the rows within the tables are qualified
by a unique identifier (UUID) for each broker. The schema user ID
is set by -u dataSourceUserId (if you specified
this parameter on the mqsicreatebroker or mqsichangebroker command),
or by -i serviceUserId (if you did not specify
the -u parameter).
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.
The following table, and the accompanying notes, indicate the minimum levels of products that are supported for databases on each operating system. For the latest information on all supported platforms, visit the WebSphere Event Broker Requirements Web site.
Operating system | DB2®1+2 | Microsoft® SQL Server | Oracle1+3 | Sybase1 |
---|---|---|---|---|
AIX® | 8.24 |
2000 SP3a6 |
9i Release 2 Patch Set 4 |
12.5 |
HP-UX on Itanium | 8.24 |
Not supported | 10g Release 2 |
Not supported |
HP-UX on PA-RISC | 8.24 |
2000 SP3a6 |
9i Release 2 Patch Set 4 |
12.5 |
Linux® on POWER™ | 8.24 |
Not supported | Not supported | Not supported |
Linux on x86 | 8.24+8 |
2000 SP3a6 |
9i Release 2 Patch Set 4 |
12.5 |
Linux on System z® | 8.24+10 |
Not supported | Not supported |
Not supported |
Solaris on SPARC | 8.24+11 |
2000 SP3a6 |
9i Release 2 Patch Set 4 |
12.5.3 |
Solaris on x86-64 | 8.24+11 |
Not supported | 10g Release 1 |
12.5.3 |
Windows® | 8.24+12 |
2000 SP3a |
9i Release 2 Patch Set 4 |
12.5 |
z/OS® | 7.114 |
Not supported | Not supported | Not supported |
DB2 Version 8.2 is functionally equivalent to Version 8.1 Fix Pack 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.
MQSI_SIGNAL_EXCLUSIONS=10
If you have installed Oracle, you must use the 32-bit client libraries.
If you do not require XA, you can install WebSphere MQ Version 6.0 (64-bit). XA is not supported because the 64-bit queue manager requires 64-bit ODBC drivers and switch files, which are not supplied.