Network Deployment (Distributed operating systems), v8.0 > Administer applications and their environment > Administer Scheduler service > Manage schedulers > Create the database for schedulers


Create scheduler tables using DDL files

This topic provides the steps for creating 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.


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:

    • Create Apache Derby tables for schedulers

    • Create DB2 tables for schedulers.

    • Create DB2 tables for z/OS 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 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


Related


Create Apache Derby tables for schedulers
Create DB2 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
Create scheduler databases


Related


Scheduler table definition

+

Search Tips   |   Advanced Search