Configure databases

Before transferring default data to the production database server, prepare the database server. Database preparation includes creating user IDs and databases. For this installation path, stand-alone production server, remote databases servers are used.

Prerequisites

Prepare the AIX operating system

Installing WebSphere Portal on AIX

Select the database server that are using.

• Prepare DB2 on AIX for a stand-alone production server

  You can install DB2 on the same server as WebSphere Portal, also referred to as local, or on a different server, referred to as remote. If you plan to use a local DB2 database, scripts are provided to simplify the database creation and transfer. More information about the local database is provide in the single server installation instructions. For a remote database complete the transfer manually.

• Prepare DB2 on HP-UX, Linux, and Solaris for a stand-alone production server

  You can install DB2 on the same server as WebSphere Portal, also referred to as local, or on a different server, referred to as remote. If you plan to use a local DB2 database, scripts are provided to simplify the database creation and transfer. More information about the local database is provided in the single server installation instructions. For a remote database complete the transfer manually.

• Prepare DB2 for z/OS for a stand-alone production server

  Setting up the DB2 for z/OS database includes creating user IDs and databases on a remote server.

• Set up a remote Oracle database on AIX, HP-UX, Linux, and Solaris for a stand-alone production server

  Setting up the Oracle database includes creating user IDs and databases on a remote server. A task is provided to assist with creating the users. Before you can use the task, modify properties files.

• Set up a remote Oracle RAC database on AIX, HP-UX, Linux, and Solaris for a stand-alone production server

  Setting up the Oracle RAC database includes creating user IDs and databases on a remote server. A task is provided to assist with creating the users. Before you can use the task, modify properties files.

• Set up a remote SQL Server database on Windows for a stand-alone production server

  To setup a remote Microsoft SQL Server Enterprise Edition database, create user IDs and databases on a remote server. Tasks are provided to assist with creating the user IDs and the databases. Before you can use the tasks, modify properties files.

• Verify databases

  After you configure WebSphere Portal to work with your database, test the database connection to ensure that it operates correctly. Then verify that all database transactions work properly within the WebSphere Portal environment.

  For example, all portal pages should display without HTTP 404 errors, and there should be no database layer-related exceptions in the SystemOut.log and SystemErr.log files.

Parent topic:

Set up a stand-alone server on AIX

Previous topic:

Installing WebSphere Portal on AIX

Next topic:

Prepare a remote Web server when portal is installed on AIX

---