Windows stand-alone: Create remote DB2 for z/OS databases

A remote database resides on a different machine than WebSphere Portal. You must manually create the required databases before configuring WebSphere Portal to work with DB2 for z/OS®.

Before you begin, complete the following prerequisites:


Prerequisites


Install DB2 for z/OS
Use JCL templates to set up DB2 for z/OS
Create DB2 for z/OS users

Use the following steps to set up WebSphere Portal with a remote instance of DB2 for z/OS. Refer to Planning for DB2 for z/OS for a list of databases and table space names. If you are configuring multiple WebSphere Portal instances to use a single DB2 subsystem, be sure to use the database and table space names associated with the WebSphere Portal instance you are setting up.

  1. CREATE DATABASE releasenameonzos CCSID UNICODE;

  2. CREATE DATABASE communitynameonzos CCSID UNICODE;

  3. CREATE DATABASE customizationnameonzos CCSID UNICODE;

  4. Execute the steps in the topic Creating the Java™ Content Repository database.

  5. CREATE DATABASE fdbkdbnameonzos CCSID UNICODE;

  6. CREATE TABLESPACE fdbkdbts IN fdbkdbnameonzos USING STOGROUP SYSDEFLT PRIQTY 5000 SECQTY 500 LOCKSIZE ROW DEFINE NO;

  7. CREATE DATABASE lmdbnameonzos CCSID UNICODE;

  8. CREATE TABLESPACE lmdbts IN lmdbnameonzos USING STOGROUP SYSDEFLT PRIQTY 5000 SECQTY 500 DEFINE NO;


Parent

Set up a remote DB2 for z/OS database


Previous

Create DB2 for z/OS users


Next topic

Grant privileges to DB2 for z/OS database users

  This version (3) 2011/12/15 documentation refresh


+

Search Tips   |   Advanced Search