Creating scheduler tables using DDL files

Create scheduler tables using DDL files.

Before you begin

Your database system must be installed and available.

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

About this task

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

Procedure

  1. Verify that your database is created. Refer to the Creating scheduler databases topic.
  2. Create the database tables according to the instructions for your database system:
    • Creating Apache Derby tables for schedulers
    • Creating DB2® tables for schedulers.
    • Creating DB2 tables for z/OS® for schedulers.
    • [IBM i]Creating DB2 for iSeries tables for schedulers.
    • Creating Informix® tables for schedulers.
    • Creating Microsoft SQL Server tables for schedulers.
    • Creating Oracle tables for schedulers.
    • Creating Sybase tables for schedulers.
    The following scripts are deprecated, but will still work:
    Table 1. Deprecated scripts. Deprecated DDL scripts
    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