This topic provides the steps for
creating 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
- Verify that your database is created.
Refer to the Creating scheduler
databases topic.
- 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.
- 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 |