Increasing the databases connections pool size for Dashboard Client

Dashboard Client communicates with the Repository, Runtime and Historical databases using Java™ Database Connectivity (JDBC), which manages reusable pools of database connections.

There must be sufficient connections in these pools to accommodate multiple simultaneous Dashboard sessions. If there are no sufficient connections in each of these pools, you may experience long, unexpected and unpredictable delays in their Dashboard activities. The recommended initial maximum connection pool size is 100. If long delays are experienced, check that the maximum size of each pool is 100. If delays persist, try increasing the maximum size of each pool. If delays persist after increasing the pool sizes, look for solutions elsewhere

There are five relevant data sources that their corresponding maximum connection sizes should be increased. Each of these data sources belongs to a specific JDBC Provider as follows:
  • JDBC Provider name: MonitorDB2XADriver1
    • Data source name: HistoricalDBDataSource
    • Data source name: RepositoryDBDataSource
    • Data source name: RuntimeDBDataSource
  • JDBC Provider name: wpsdbJDBC
    • Data source name: wmmDS
    • Data source name: wpsdbDS

The data pool maximum sizes are set from the WebSphere® Application Server administrative console. To increase the maximum size of the databases connection for each of the above data sources:

  1. From the WebSphere Application Server administrative console navigation tree, select Resources > JDBC Providers.
  2. From the JDBC Providers list, select <JDBC_Provider_Name>.
  3. Click the Data Sources link.
  4. From the Data Sources list, select <Data_Source_Name>.
  5. Click the Connection pool properties link.
  6. In the Maximum connections field, type the value of the maximum connections you need.
  7. Click OK.
  8. Click Save in the Message information box to apply your changes. The Save page appears.
  9. Click Save.

Copyright IBM Corporation 2005, 2006. All Rights Reserved.