The broker uses ODBC to access its database and you must set up an ODBC connection on each broker system. This topic describes the connections that a broker database needs, and the ODBC parameters that you must tailor for the connections:
To define the connection, link to the topic for your operating system:
The number of connections required by the broker to its database depend to some extent on the actions of the message flows it is processing. The following connections are required for each broker:
If you are using the same database for several brokers, you must take account of all brokers in your calculations.
The connections for neighbors and publication nodes are only required if you are using retained publications.
When you start a broker, it opens all connections that it requires to the broker database for its own operation. When you stop the broker, it releases all current database connection handles.
If you are using DB2 for your database, the default action taken by DB2 is to limit the number of concurrent connections to a database to the value of the maxappls configuration parameter. The default for maxappls is 40. If you believe the connections that the broker might require exceed the value for maxappls, increase this and the associated parameter maxagents to new values based on your calculations.
Configure the template files by updating the following parameters. Some parameters are not applicable to all databases, as shown.
<servername or IP address>, <portnumber>
For example Sybaseserver, 5000. You can also specify the IP address directly, for example 199.226.224.34, 5000. You can find the port number in the Sybase interfaces file which is typically named interfaces, interfac, or sql.ini, depending on the operating system.
Notices |
Trademarks |
Downloads |
Library |
Support |
Feedback
![]() ![]() |
ah14440_ |