Defining a cell wide default grid endpoint data source

When the Compute Grid application is installed on a server or a cluster, the Compute Grid execution environment (GEE) is automatically deployed on the selected server or cluster. The server or cluster is selected using the default Derby jdbc/lree data source.

About this task

Configure all new GEE deployments within the cell to use a different default data source.

Procedure

  1. Define the XA JDBC provider for the database through the administrative console. For more information about defining a new JDBC provider, refer to the JDBC provider documentation.
  2. Create the grid endpoint data source using the JDBC provider through the administrative console

    Define the data source at the cell level. This definition guarantees that the database is available for each application server that hosts GEE.

  3. Update the GRID_ENDPOINT_DATASOURCE WebSphere variable with the newly created grid endpoint data source JNDI name. On the WebSphere administrative console, expand Environment and click WebSphere Variables. On the WebSphere Variables panel, click GRID_ENDPOINT_DATASOURCE and enter a valid JNDI name in the value field.
  4. If the WebSphere variable, GRID_ENDPOINT_BACKENDID, does not exist, run the addGEEProperty.py script. This script is run using the wsadmin command and creates a WebSphere cell level variable named GRID_ENDPOINT_BACKENDID. For example, from the WAS_INSTALL_ROOT/bin directory of the Deployment Manager node:

    ./wsadmin.sh -user xxxx -password xxxx -f addGEEProperty.py

  5. Update the GRID_ENDPOINT_BACKENDID WebSphere variable with a valid backend ID.

    On the WebSphere administrative console, expand Environment and click WebSphere Variables. On the WebSphere Variables panel, click GRID_ENDPOINT_BACKENDID and enter a valid backend ID in the value field.

    The following is a list of valid grid endpoint backend ID values:
    • DERBY_V100_2
    • DB2UDBOS390_V8_1
    • DB2UDBOS390_V9_1
    • DB2UDBNT_V8_1
    • DB2UDBNT_V82_1
    • DB2UDBNT_V91_1
    • DB2UDBNT_V95_1
    • ORACLE_V9_1
    • ORACLE_V10_1
    • ORACLE_V11_1
  6. Save and synchronize the configuration.

Results

All new WebSphere Grid Endpoints will be installed using the data source specified in the GRID_ENDPOINT_DATASOURCE variable and the database backend ID specified in the GRID_ENDPOINT_BACKENDID variable.