Manual database creation and setup

For most databases, tasks are provided to create the database (create-database), setup the database users (setup-database), and transfer the default data to the database (database-transfer). However, if you want to create databases manually and transfer the data manually, you can use the alternate configuration instructions provided in this section.

The database and WebSphere Portal should be installed.

In the typical installation and setup scenarios, such as Setting up a stand-alone production server, instructions are included to create and setup databases using the provided database tasks. The manual instructions included in this section can be used instead of the automated tasks, but should not be used in conjunction with tasks. The following manual tasks are provided:

• DB2 to create users, create the databases (including the JCR database), and transfer the data, but only when DB2 is installed on the same server as WebSphere Portal.

• SQL Server for create users, create the databases (including the JCR database), and transfer the data.

• Oracle to create users, grant privileges, and transfer the default data. A task is not provided for database creation.

Manual tasks are not provided for the following:

• Remote DB2 databases

• DB2 on Z/OS

• DB2 on i5/OS

• Oracle database creation

• Set up a local DB2

  Instead of using the provided tasks to create the local database and transfer the data, you can use the manual steps.

• Manually creating users and granting privileges for Oracle

  Instead of using the provided tasks to create the database users and grant privileges, you can use the manual steps.

• Create users and databases for SQL Server on Windows

  Instead of using the provided tasks to create the database users and databases, you can use the manual steps.

Parent topic:

Installing WebSphere Portal

---