WebSphere connection pool: define data source in Sterling Selling and Fulfillment Foundation

To define the datasource name to Sterling Selling and Fulfillment Foundation, add the following entry in the <INSTALL_DIR>/properties/customer_overrides.properties file (see Property file):

   jdbcService.<dbvendor>Pool.datasource=<datasource name>
   

Where <dbvendor> = db2 or oracle

For example: jdbcService.db2Pool.datasource=MetadataDS

Additionally, to use the WebSphere® datasource, ensure that you set the -Dvendor JVM argument to websphere. For example: -Dvendor=websphere

Note: In a sharded environment, you must provide the Metadata shard’s datasource as the value.

At initialization, Sterling Selling and Fulfillment Foundation uses the datasource name to find the connection pool in WebSphere. In the example above, the datasource name is MetadataDS.

IBM® recommends that you benchmark your application before migration to production to ensure that these values are set optimally. IBM also recommends that you continually monitor the connection pool usage levels to ensure that these parameters are set optimally.