WebSphere Application Server Network Deployment, Version 6.0.x     Operating Systems: AIX, HP-UX, Linux, Solaris, Windows

Creating DB2 for iSeries databases for schedulers

Why and when to perform this task

This topic describes how to create DB2 for iSeries databases for scheduler, using data definition language (DDL) or structured query language (SQL) files.

Steps for this task

  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.

Result

The DB2 for iSeries database for the scheduler exists.



Related reference
DB2 tuning parameters
Vendor-specific data sources minimum required settings

Task topic    

Terms of Use | Feedback

Last updated: Dec 11, 2005 4:07:15 PM CST
http://publib.boulder.ibm.com/infocenter/wasinfo/v6r0/index.jsp?topic=/com.ibm.websphere.nd.doc/info/ae/scheduler/tasks/tsch_codb2i.html

© Copyright IBM Corporation 2002, 2005. All Rights Reserved.
This information center is powered by Eclipse technology. (http://www.eclipse.org)