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.