+

Search Tips   |   Advanced Search

AIX 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 beginning, complete the following prerequisites:

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 we 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 we are setting up.

  1. CREATE DATABASE releasenameonzos CCSID UNICODE;

  2. CREATE DATABASE communitynameonzos CCSID UNICODE;

  3. CREATE DATABASE customizationnameonzos CCSID UNICODE;

  4. CREATE DATABASE fdbkdbnameonzos CCSID UNICODE;

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

  6. CREATE DATABASE lmdbnameonzos CCSID UNICODE;

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


Parent: AIX clustered server: Set up a remote DB2 for z/OS
Previous: AIX clustered server: Create DB2 for z/OS users
Next: AIX clustered server: Grant privileges to DB2 for z/OS database administration users