Network Deployment (Distributed operating systems), v8.0 > Administer applications and their environment > Administer the batch environment > Administer the batch environment > Configure WebSphere grid endpoints
Create the job scheduler and grid endpoint database
We can create a database for the job scheduler and grid endpoint if you do not use the default Apache Derby database. The job scheduler stores job information in a relational database while the grid endpoint uses the database to track the progress of a batch job.
When you install the product, one Derby JDBC provider is created. The Derby JDBC provider contains two data sources. One is the default Derby data source, JNDI name jdbc/lrsched, that points to the default Derby job scheduler database. The other, JNDI name jdbc/pgc, is the batch execution environment data source. If you decide to use the default data source you do not need to create the job scheduler database. The default Derby database for the job scheduler is created when the job scheduler host (deployment target) is selected through the admin console. The default Derby database for the endpoint is created when a batch application is first installed on a node. Embedded Derby databases cannot be shared by multiple processes and are unsuitable for environments where the job scheduler must move from one node to another. For example, the job scheduler must move from one node to another in high availability scenarios.
The product supports Derby, DB2, and Oracle databases. We can use the following steps to configure the job scheduler and grid endpoint database if you decide to use a database other than the Derby database. When you create the database manually, the job scheduler and grid endpoint can use the same database.
Procedure
- Select the correct file based on the type of database that you are going to use.
New feature: The product provides DDL files except for DB2 on the z/OS operating system. Use the DDL files to define the job scheduler database in the <WAS_install_root>/util/Batch directory. The DDL files for creating the job scheduler database are named CreateLRSCHEDTablesXxx.ddl where Xxx indicates the type of database manager that the scripts are intended for. These same DDL files are used for the grid endpoint.
- See the documentation of your database vendor for details on customizing scripts and using the database tools to run it.
What to do next
After creating the database, complete the following steps.
- Define the XA JDBC provider for the database through the admin console.
Consult the JDBC provider documentation for more information about defining a new JDBC provider.
- Create the data source using the JDBC provider through the admin console.
Define the data source at the cell level. Doing so guarantees that the database is available for each application server that hosts the job scheduler.
- Verify that the database has been created by testing the connection on the data source that you created in the previous step.
- Configure the job scheduler by selecting the JNDI name of the newly created data source in the job scheduler panel.
- Specify the JNDI name of the data source that you created in a previous step as the value of the GRID_ENDPOINT_DATASOURCE variable.
Configure the job scheduler
Configure WebSphere grid endpoints
Verify the job scheduler installation
Related
Administrative roles and privilegesNew feature: Configure a JDBC provider and data source