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