You can start multiple brokers for a database. Multiple brokers are used to:

  • Scale up the number of users.
  • Support different types of users (ABL and SQL).
  • Support multiple types of data usage such as online transactional processing, reporting, and business intelligence.
  • Facilitate data flow across networks by invoking various startup parameters for clients, servers, and brokers.

With dedicated ABL and SQL brokers, you can:

  • Avoid depletion of the connection pool due to simultaneous ABL and SQL client connections.
  • Enforce both ABL and SQL security and ensure that only clients with appropriate privileges can access specific data.
  • Control the number of servers (ABL or SQL) per broker.
  • Control the number of clients (ABL or SQL) per server.