Portal, Express Beta Version 6.1 Operating systems: i5/OS, Linux,Windows

Creating remote databases

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

• These instructions assume that you will use a local IBM^® DB2 Universal Database™ Enterprise Server Edition Connect to connect to a remote DB2 for z/OS server, and that IBM WebSphere^® Application Server, WebSphere Portal, and DB2 Connect will be installed on the same machine.
• To run SQL statements, you can use a tool like SPUFI. The specified statements include CREATE STOGROUP, CREATE DATABASE and CREATE TABLESPACE. For CREATE STOGROUP you have to replace the icmvolumes and icmvcat variables with volume serial numbers and a catalog name for your environment. For CREATE TABLESPACE you can specify a specific BUFFERPOOL. Otherwise the default bufferpool, BP0, will be used, which is not recommended for performance reasons. Refer to the DB2 Universal Database for OS/390 and z/OS SQL Reference for a description of these options.
• Ensure that a TEMP database is created for your subsystem. You can use the following statements to create a TEMP database:

  CREATE DATABASE db_name AS TEMP;
  CREATE TABLESPACE ts_name IN db_name;

• Log on to the DB2 subsystem on the host server. DB2 system administrator rights are needed to create the databases.
• Replace variables as follows:

  • releasenameonzos, communitynameonzos, and customizationnameonzos are the WebSphere Portal Express databases for WebSphere Portal Express and Member Manager data.
  • fdbkdbnameonzos and fdbkdbts are the database and table space, respectively, for Feedback data.
  • lmdbnameonzos and lmdbts are the database and table space, respectively, for LikeMinds data.

1. CREATE DATABASE releasenameonzos CCSID UNICODE;
2. CREATE DATABASE communitynameonzos CCSID UNICODE;
3. CREATE DATABASE customizationnameonzos CCSID UNICODE;
4. Execute the steps in the Creating the DB2 Content Manager Runtime Edition database topic.
5. CREATE DATABASE fdbkdbnameonzos CCSID UNICODE;
6. CREATE TABLESPACE fdbkdbts IN fdbkdbnameonzos USING STOGROUP SYSDEFLT PRIQTY 5000 SECQTY 500;
7. CREATE DATABASE lmdbnameonzos CCSID UNICODE;
8. CREATE TABLESPACE lmdbts IN lmdbnameonzos USING STOGROUP SYSDEFLT PRIQTY 5000 SECQTY 500;