Before you begin
This task requires you to configure a database and make it available. See the "Creating DB2 databases for schedulers" topic for more information.Why and when to perform this task
This topic describes how to create tables for scheduler on DB2 databases, using data definition language (DDL) or structured query language (SQL) files.Steps for this task
%WAS_HOME%\Scheduler\createTablespaceDB2.ddl, %WAS_HOME%\Scheduler\createSchemaDB2.ddl, %WAS_HOME%\Scheduler\dropSchemaDB2.ddl, and %WAS_HOME%\Scheduler\dropTablespaceDB2.ddl.
db2 connect to scheddb
db2 -tf createTablespaceDB2.ddlVerify that the script output contains no errors. If there were any errors, you can drop the table space using the following script:
dropTablespaceDB2.ddl
dropSchemaDB2.ddl
Result
The DB2 tables and schema for the scheduler exist.Related tasks
Creating DB2 databases for schedulers
Related reference
DB2 tuning parameters
Vendor-specific data sources minimum required settings