Create scheduler tables using DDL files

Create scheduler tables using DDL files.

Your database system must be installed and available.

The scheduler requires a database, a Java™ Database Connectivity (JDBC) provider, and a data source.

Complete the following steps to create scheduler tables using DDL files.

1. Verify that the database is created. Refer to the Creating scheduler databases topic.

2. Create the database tables according to the instructions for the database system:

   • Create Apache Derby tables for schedulers

   • Create DB2 tables for schedulers.

   • Create DB2 tables for z/OS for schedulers.

   • Create DB2 for iSeries tables for schedulers.

   • Create Informix tables for schedulers.

   • Create Microsoft SQL Server tables for schedulers.

   • Create Oracle tables for schedulers.

   • Create Sybase tables for schedulers.

   The following scripts are deprecated, but will still work:

   Deprecated script	New script
   createSchemaDB2.ddl	createSchemaMod1DB2.ddl
   createSchemaDB2iSeries.ddl	createSchemaMod1DB2iSeries.ddl
   createSchemaDerby.ddl	createSchemaMod1Derby.ddl
   createSchemaMSSQL.sql	createSchemaMod1MSSQL.sql
   createSchemaInformix.sql	createSchemaMod1Informix.sql
   createSchemaOracle.ddl	createSchemaMod1Oracle.ddl
   createSchemaSybase12.ddl	createSchemaMod1Sybase12.ddl
   dropSchemaMSSQL.sql	dropSchemaMod1MSSQL.sql
   dropSchemaDB2.ddl	dropSchemaMod1DB2.ddl
   dropSchemaDB2iSeries.ddl	dropSchemaMod1DB2iSeries.ddl
   dropSchemaDerby.ddl	dropSchemaMod1Derby.ddl
   dropSchemaInformix.sql	dropSchemaMod1Informix.sql
   dropSchemaOracle.ddl	dropSchemaMod1Oracle.ddl
   dropSchemaSybase12.ddl	dropSchemaMod1Sybase12.ddl

• Create Apache Derby tables for schedulers
  Create tables for schedulers on Apache Derby databases using DDL or structured query language (SQL) files.

• Create DB2 tables for schedulers
  Create tables for scheduler on DB2 databases using DDL or structured query language (SQL) files.

• Create DB2 for z/OS tables for schedulers
  Create tables for a scheduler on a DB2 for z/OS database using DDL or structured query language (SQL) files.

• Create DB2 for iSeries tables for schedulers
  Create tables for scheduler on DB2 for iSeries databases using DDL or structured query language (SQL) files.

• Create Informix tables for schedulers
  Create tables for schedulers on Informix databases using DDL or structured query language (SQL) files.

• Create Microsoft SQL Server tables for schedulers
  Create tables for schedulers on Microsoft SQL Server databases using DDL or SQL files.

• Create Oracle tables for schedulers
  Create tables for schedulers on Oracle databases using DDL or SQL files.

• Create Sybase tables for schedulers
  Create tables for schedulers on Sybase databases using DDL or SQL files.

Related tasks

Create scheduler databases

Scheduler table definition