WebSphere connection pool: define data source in Sterling Order Management System Software

You can define a data source in the Sterling™ Order Management System Software.

To define the datasource name to Sterling Order Management System Software, 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 Order Management System Software 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.