AIX clustered server: Install DB2

View information on installing DB2 for use with WebSphere Portal.

Before you begin:

• Make sure the OS is set up with updated kernel parameters according to the recommendations in the DB2 Quick Beginnings guide at DB2 Technical Support.

• When you install DB2 using the DB2 installation program, it automatically creates a DB2 administrative user with the correct OS rights.

• Ensure that you have enough disk space for the DB2 instance home directory to be able to create the required databases.

• If you are using DB2 Version 9.1 use the db2jcc.jar file. You will need to replace references to db2jcc4.jar with db2jcc.jar in this topic. If you are not using this specific version of DB2, use the db2jcc4.jar file.

• If you are using DB2 for z/OSVersion 8, use the db2jcc.jar file. You will need to replace references to db2jcc4.jar with db2jcc.jar in this topic. If you are not using this specific version of DB2 for z/OS, use the db2jcc4.jar file.

• If you plan to transfer data from multiple portals sharing the same DB2 database, you should increase the default value for the number of concurrently active databases (NUMDB). The value for NUMDB depends on how many databases are concurrently used on the DB2 instance which also maintains the databases for WebSphere Portal. For example, to change the default number (NUMDB) to 30, enter the following command at the database prompt: UPDATE DATABASE MANAGER CONFIGURATION USING NUMDB 30. You will receive a message that confirms a successful completion of the update.

1. To install DB2 or the DB2 client and the required fix pack, follow the instructions that are provided with the DB2 documentation.

2. If DB2 is installed on another system than WebSphere Portal, perform the following instructions:

   • For JDBC Type 2 drivers only: The appropriate DB2 client must be installed on the same system as WebSphere Portal and have the same name as the server profile name.

   • For JDBC Type 4 drivers only: Copy the driver jar files to the Portal server. It is recommended that you place these driver files within the WP_PROFILE directory; for example:
     WP_PROFILE/PortalServer/dbdrivers/db2jcc4.jar
     WP_PROFILE/PortalServer/dbdrivers/db2jcc_license_cu.jar

3. Open the services file on the DB2 system. Ensure that the DB2 instance port was added to the services file during the DB2 installation.

   • Edit file /etc/services.

   • Ensure that DB2_db2inst1 50000/tcp, where db2inst1 is the DB2 instance name, is in the services file. If you do not see DB2_db2inst1 50000/tcp in the services file, add this entry to the services file.
     Ensure that the port number used is not in use. If port number is already in use, select a different port number.

4. If you are using the JDBC driver in type 2 mode, configure DB2 client with the following commands.
   If you are using a remote database, complete this step separately from the WebSphere Portal installation.

   • db2 update dbm cfg using tp_mon_name WAS

   • db2 update dbm cfg using spm_name hostname, where hostname is the host name of WebSphere Portal.

   Because the default for spm_name is the hostname itself, specifying the hostname parameter is optional. If hostname is more than eight characters, use empty double quotes (" "). For example, db2 update dbm cfg using spm_name " ".

Parent

AIX clustered server: Set up a DB2 database

Next topic

AIX clustered server: Modify DB2 database properties

 

+

Search Tips   |   Advanced Search