Program guide > (deprecated) Partitioning facility > Partitioning facility programming > Proxy DataSource development > Configure Proxy DataSource in WebSphere eXtreme Scale


Deprecated feature: The partitioning facility (WPF) feature is deprecated. You can configure partitioning with WebSphere eXtreme Scale.


Create DB2DB2 data sources

  1. Select Resources > JDBC Providers.

  2. Create a cluster-wide DB2 Universal Java™ database connectivity (JDBC) provider.

    To create a cluster-wide JDBC provider, set the scope to cluster level and then select the cluster you want. Make sure you see a red arrow on the left of the cluster.

  3. Click New. Select DB2 as the database type. Select DB2 Universal JDBC Driver Provider as the provider type. Select connection pool data source as the implementation type.

  4. Click Next.

    The classpath of the JDBC provider uses DB2 JDBC driver jar files. Define the variables as the path where the DB2 JDBC driver jar files reside. If you have multiple nodes, and DB2 JDBC driver JAR files are in different directories, override the variables appropriately in the node level.

  5. Click Apply. Click Data Sources > Additional Properties.

  6. Under the JDBC provider, click New to create a data source with the JNDI name as jdbc/WestDS, and the name as WestDS.

  7. Select the Use this Data Source in container managed persistence (CMP) check box. This option is checked by default.

  8. Select com.ibm.websphere.rsadapter.helper.DB2UniversalDataStoreHelper as the data store helper class

  9. Select <CELL>/alias1 as the component-managed authentication alias.

  10. Set databaseName to westtest and set driverType to 2

  11. Leave others as the defaults. Click Apply.

  12. Navigate to the JDBC provider panel.

  13. Under the same DB2 Universal JDBC provider, create a datasource with the JNDI name jdbc/EastDS, naming it EastDS.

  14. Check the Use this Data Source in container managed persistence (CMP) check box. This option is checked by default.

  15. Select <CELL>/alias1 as the component-managed authentication alias.

  16. Set the databaseName to easttest and set driverType to 2.

  17. Leave others as the defaults. Click Apply.

  18. Click Save to save the configuration.

  19. Navigate back to the Data Sources page and click Test connection to test the connection.


Parent topic:

Configure Proxy DataSource in WebSphere eXtreme Scale


Related concepts

Configure proxy DataSource In WebSphere Extended Deployment