WebSphere Application Server - Express, Version 6.0.x     Operating Systems: AIX, HP-UX, Linux, Solaris, Windows

Creating 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 you need more tasks per second, you can run the scheduler daemons on larger systems or you can 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.

Why and when to perform this task

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

Steps for this task

  1. Create the database according to the description for your database system:
  2. If the database is not on the same machine as your IBM WebSphere Application Server, verify that you 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.



Sub-topics
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

Task topic    

Terms of Use | Feedback

Last updated: Jun 8, 2005 12:45:23 PM EDT
http://publib.boulder.ibm.com/infocenter/wasinfo/v6r0/index.jsp?topic=/com.ibm.websphere.express.doc/info/exp/scheduler/tasks/tsch_data.html

© Copyright IBM Corporation 2002, 2005. All Rights Reserved.
This information center is powered by Eclipse technology. (http://www.eclipse.org)