Solaris clustered server: 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


Solaris clustered server: Install DB2 for z/OS
Solaris clustered server: Modify DB2 for z/OS database properties
Solaris clustered server: Use JCL templates to set up DB2 for z/OS
Solaris clustered server: 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

Solaris clustered server: Set up a remote DB2 for z/OS database


Previous

Solaris clustered server: Create DB2 for z/OS users


Next topic

Solaris clustered server: Grant privileges to DB2 for z/OS database administration users

 


+

Search Tips   |   Advanced Search