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. 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 folder.

  The following elements are a partial listing from that 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>.

  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.