Kbase 19848: SonicMQ: How Many Broker-to-DB Connections Are Made and Why?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
02/06/2000 |
|
This solution applies to Progress SonicMQ Version 2000.x
The SonicMQ broker makes a number of connections to its database.
Multiple connections between the broker and database are required
because the broker often needs to execute several database
transactions concurrently, and each database connection allows only
one active transaction at a time. The number of connections is
independent of the number of clients connected to the broker, and is
the same regardless of the database (for example, Cloudscape, Oracle8i, MS SQL) being used. The broker establishes these connections on startup, and the number of connections remains constant until the broker is shut down.
If security is not enabled, the broker makes six connections to its
database. In a single-broker configuration with security enabled, the
broker uses two additional database connections to access the security
tables in the database, bringing the total number of connections to
eight. This is also the case for the configuration server in an
interbroker configuration with security enabled.