Create DB2 for iSeries databases for schedulers

Create DB2 for iSeries databases for scheduler using DDL or SQL files.

To create DB2 for iSeries databases for scheduler, using DDL or SQL files, use these steps.

1. Run the following command to start an interactive SQL session:
   STRSQL

2. In interactive SQL, enter this command to create the collection with an example name, scheddb:
   CREATE COLLECTION scheddb

3. Exit the interactive SQL session.

4. Change our owner for the new collection to QEJBSVR by executing the following command:
   CHGOBJOWN OBJ(scheddb) OBJTYPE(*LIB) NEWOWN(QEJBSVR)

   where scheddb is the name of the collection created in the previous step.

Results

The DB2 for iSeries database for the scheduler exists.

Related tasks

Create DB2 for iSeries tables for schedulers

Create DB2 databases for schedulers

Create DB2 tables for schedulers

Data source minimum required settings, by vendor