Create scheduler databases

 

Before you begin

Your database system must be installed and available.

It is important to know that the scheduler uses this database for storing and running tasks. The performance of schedulers is ultimately limited by the performance of the database. If we need more tasks per second, one can run the scheduler daemons on larger systems or use clusters for the session beans used by the tasks. Eventually, however, the task database becomes saturated and you then need a larger or better-tuned database system.

Multiple applications can share a scheduler database. This sharing can lower the cost of administering scheduler databases.

 

Overview

The scheduler requires a database, a JDBC provider, and a data source.

 

Procedure

1. Create the database according to the description for your database system:

   • Creating a Cloudscape database for schedulers.

   • Creating a DB2 database for schedulers.

   • Creating a DB2 database for z/OS for schedulers.

   • Creating an Informix database for schedulers.

   • Creating a Microsoft SQL Server database for schedulers.

   • Creating an Oracle database for schedulers.

   • Creating a Sybase database for schedulers.

2. If the database is not on the same machine as your IBM WebSphere Application Server, verify that one can access the database from your application server machine.

3. Configure your JDBC provider and data source. For details, see the topic Creating and configuring a JDBC provider and data source.

 

Result

The database is created and ready for you to create scheduler tables.

 

See also

Creating Cloudscape databases for schedulers
Creating DB2 databases for schedulers
Creating DB2 for z/OS databases for schedulers
Creating Informix databases for schedulers
Creating Microsoft SQL Server databases for schedulers
Creating Oracle databases for schedulers
Creating Sybase databases for schedulers

 

Related Tasks

Creating scheduler tables using DDL files

 

---