Create remote 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

Installing DB2 for z/OS

Creating 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;

  7. CREATE DATABASE lmdbnameonzos CCSID UNICODE;

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


Parent topic:

Configure WebSphere Portal to use DB2 for z/OS


Previous topic:

Creating users


Next topic:

Creating the Java Content Repository database


Related information


Manage LOB logging in DB2 for z/OS