Installing and preparing DB2
Use this information to install DB2® or DB2 pureScale for use with IBM® WebSphere® Portal.
Before you begin
- Review the database considerations.
- Ensure the database that you plan to use is supported by this version of WebSphere Portal. Refer to the list of supported databases in the WebSphere Portal detailed system requirements.
- Set up the operating system with updated kernel parameters according to the DB2 Quick Beginnings guide at DB2 Technical Support.
- When you install DB2 with the DB2 installation program, it automatically creates a DB2 administrative user with the correct operating system rights.
- Ensure that you have enough disk space for the DB2 instance home directory to be able to create the required databases.
- A DB2 instance supports a limited number (NUMDB) of concurrently active databases. Increase this value if the DB2 instance maintains databases for WebSphere Portal and other applications. The NUMDB value depends on how many databases are concurrently used on the DB2 instance. Examples of concurrent usage include two portals that access the same DB2 instance or transferring data from multiple portals that use the same DB2 instance. To change the default to 30, enter the following command at the database prompt: UPDATE DATABASE MANAGER CONFIGURATION USING NUMDB 30. A message displays that confirms a successful completion of the update.
- WebSphere Portal supports DB2 JDBC Type 2 (CLI-based) and Type 4 (JCC) drivers.
About this task
All DB2 instructions apply to DB2 pureScale except where specifically noted.
Procedure
What to do next
Use the Configuration Wizard to set up and configure the database to work with WebSphere Portal. You can use the wizard to create custom scripts that you or your database administrator can use to configure the database. You can also use the wizard to automatically set up and configure the database. The wizard creates instructions and scripts that are based on your selections and provided data.
When you use the wizard and provide information about the database
for your environment, be aware of the following considerations:
- The value for the database name, database server node, or schema name must be unique.
- When the DB2 Universal JDBC driver (type 4 mode) is used, connect to the database directly. Do not connect to an alias database (gateway), instead specify the real database name in the JDBC connection URL (dbdomain.DbUrl) and in the database name property (dbdomain.DbName).
- The Configuration Wizard's default configuration uses the instance (db2inst1) that is created by the installation program. Using separate databases can improve scalability and performance. The wizard allows you to change the default behavior. You can select whether each of the portal database domains exist in one or many instances.
- Your database name (dbdomain.DbName) cannot exceed eight characters.
- You cannot use the Database Transfer option in the configuration wizard to assign custom table spaces on your database server. You can perform manual steps to assign custom table spaces. Go to Assigning custom table spaces for more information.
(Optional) After you transfer your data to DB2, run a configuration task to enable support for high availability recovery (HADR) and rollforward recovery.