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
- 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 |