This section is designed to give the DB2 database administrator an overall picture of WebSphere Portal database requirements. See Which Distributed Edition of DB2 UDB Version 8 is Right for You? if you need help determining which DB2 version to use.
After the DB2 software has been installed, create the required databases and users and grant the proper privileges to those users. If you are using a local DB2, WebSphere Portal can create the databases for you. The database names and users in this section are arbitrary values to provide consistency throughout the documentation. During installation and configuration, replace these values with values in your environment. While this section reflects the recommended database architecture for WebSphere Portal, other configurations are possible.
The following database user with administrative rights is recommended:
Note: If you choose to use one database to hold all WebSphere Portal, Member Manager, and content publishing information, create at least one user for the shared WebSphere Portal and Member Manager tables and another user for the content publishing tables. See Member Manager in Managing Security for information on Member Manager.
The following schemas are recommended:
Note: When determining the amount of storage space that is needed, consider the following information:
The WebSphere Portal architecture allows each of these schemas to exist in one or many databases. However, the following architecture is strongly recommended:
| Instance | Database |
|---|---|
| db2 | wps50 |
| db2 | wpcp50 |
| db2 | fdbk50 |
where db2 is the name of the default instance that is created by the DB2 installation program.
The following table demonstrates what information is contained in the required areas.
| Database/Schema | Database/Schema function |
|---|---|
| wps50 | Stores information about user customizations, such as Pages, and user and login information. |
| wpcp50 | Contains authoring and configuration. |
| fdbk50 | Contains the information that is logged by your Web site for generating reports for analysis of site activity. |
In a local database environment, WebSphere Portal and DB2 are installed on the same machine.
Figure 1. Local Database Environment
|
||||||||||||||||||
In a remote database environment, WebSphere Portal and a DB2 Connect are installed on one machine (the local machine). The DB2 server is installed on a separate machine (the remote machine).
Figure 2. Remote Database Environment
|
|
||||||||||||||||||||||||||||||||
You have completed this step. Continue to the next step by choosing one of the following topics:
| Related information |
|---|