Connectivity

These are frequently asked questions about connectivity.

• How does IBM® Sterling Control Center Monitor access the database servers?

  IBM Sterling Control Center Monitor uses the Java Database Connectivity (JDBC) interface to connect to database servers.

• What are the database servers that IBM Sterling Control Center Monitor supports?

  For the list of supported databases, see System Requirements.

• Does IBM Sterling Control Center Monitor ship with all the required JDBC drivers?

  No, you have to obtain the required JDBC drivers for your databases. You will be able to get the JDBC drivers for that server (either as part of the database software or directly from the database vendor).

• How many database connections are created by IBM Sterling Control Center Monitor?

  IBM Sterling Control Center Monitor maintains a pool of database connections. By default, the number of connections in the pool can equal the number in Simultaneous Pollers (found in System Settings) + 10 + Jetty Web Server connections (found in installation_directory/web/ccbase/webapps/application.properties). IBM Sterling Control Center Monitor may create up to that many database connections with the Production database.

  To limit the number of database connections to a certain value, edit the JDBCService.xml file, located in the installation directory/conf/services/system and application.properties, located in the installation_directory/web/ccbase/webapps folder.

  Limiting database connections from Event Processor:

  The following elements are a partial listing from JDBCService.xml file.

  <maxpool>50</maxpool>
  <dynamicConnections>true</dynamicConnections>

  To limit the number of connections to a certain value, change the “true” value to “false” and substitute a new value between <maxpool> and </maxpool>.

  Limiting database connections from Web Server:

  The following elements are a partial list from the application.properties file.

  spring.datasource.hikari.maximum-pool-size=50

  Customize above line to limit database connections from Web Server.

  Customizations must be applied to each instance of the Control Center Cluster.

  Attention: IBM Sterling Control Center Monitor must be restarted for this change to take effect.

  If you change the maxpool value to a value much less than Simultaneous Pollers, node services within IBM Sterling Control Center Monitor could be forced to compete for database connections. This in turn could affect IBM Sterling Control Center Monitor performance.