Creating DB2 for iSeries databases for schedulers

This topic describes how to 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

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



In this information ...


IBM Redbooks, demos, education, and more

(Index)

Use IBM Suggests to retrieve related content from ibm.com and beyond, identified for your convenience.

This feature requires Internet access.

Task topic Task topic    

Terms and conditions for information centers | Feedback

Last updatedLast updated: Aug 30, 2013 10:47:11 PM CDT
http://www14.software.ibm.com/webapp/wsbroker/redirect?version=pix&product=was-nd-iseries&topic=tsch_codb2i
File name: tsch_codb2i.html