Create DB2® for iSeries databases
for scheduler using data definition language (DDL) or structured query
language (SQL) files.
About this task
To create DB2 for iSeries databases
for scheduler, using data definition language (DDL) or structured
query language (SQL) files, use these steps.
Procedure
- Run the following command to start an interactive SQL session:
- In interactive SQL, enter this command to create the collection
with an example name, scheddb:
CREATE COLLECTION scheddb
- Exit the interactive SQL session.
- Change the 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 you created in the previous step.
Results
The DB2 for iSeries database for the scheduler
exists.