Increasing the connection pool size for Member Manager

If you use DB2 with WebSphere Portal, the performance of SQL statements can be impaired after many updates, deletions, and insertions to the database instance for Member Manager. To improve performance, perform the following procedures:

  1. To increase the connection pool size for the Member Manager database instance, complete the following steps:
    1. Log in to the Administrative Console for WAS.
    2. In the left navigation area, navigate to Resources-JDBC Providers-wps50JDBC-Data Sources.
    3. In the list of data sources, click wmmDS.
    4. Click the Connection Pooling tab.
    5. Set the Maximum pool size field. For guidance, see the Tuning Guide in the WAS Version 5 Information Center.

  2. For the database instance, run the following command to obtain the current statistics for the data: 

    db2 reorgchk update statistics on table all

For the latest information about this topic, see the WebSphere Portal Information Center at http://www.ibm.com/websphere/portal/library.

 

See also