+

Search Tips   |   Advanced Search

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


Related tasks

  • Create scheduler databases

  • Scheduler table definition