Configure WebSphere Portal Express to use DB2

This section provides information on how to manually transfer data to the DB2 database you have installed and set up. Follow these steps to transfer WebSphere Portal Express, and DB2 Content Manager databases to DB2.

Before you begin:
Ensure that the following prerequisites are met:

Supported database software is installed.
Databases and users are correctly set up.

Tips:

The steps for transferring data to another supported database section provides instructions for manually transferring data. Instead of performing the following steps, you can use the configuration wizard, which is a graphical user interface, to transfer data to another supported database.
A configuration template might exist to support these instructions. Refer to the wp_profile_root/ConfigEngine/helpers directory for available configuration templates. Use the configuration template to update the wkplc.properties, wkplc_comp.properties, and wkplc_dbtype.properties files, as described in the topic Configuration program, according to the property descriptions and recommended values provided. If you do not want to use a configuration template, follow the steps in this task.
If you are transferring from Oracle, the open_cursors setting should be set to 1500 by default. If you are using Java Content Repository, this value might need to be increased based on the table count in the Java Content Repository schema.
Be sure that DB2 is started by checking the service. If attempts to restart result in a logon failure message, then go to the DB2 properties and reenter the password.

Working with properties files:

The WebSphere Portal Express database can be used to hold information for applications such as Personalization, Feedback and LikeMinds. Use similar naming conventions for property values such as release.DbName, jcr.DbName, feedback.DbName, and likeminds.DbName. For example:
- release.DbName=wpsdb
- jcr.DbName=jcrdb
- feedback.DbName=fdbkdb
- likeminds.DbName=lkmddb
If you are using a remote database, enter the values for the remote server.
Use forward slash (/) instead of backslash (\).
There might be additional database properties other than those listed here. Only change the properties within this task and skip all other properties.
The recommended value listed for each property represents the specific information that is required to configure WebSphere Portal Express to your target database.
Depending on which database domain has to be configured, replace dbdomain with:
- release
- customization
- community
- jcr
- feedback
- likeminds
The values for at least one of the following properties must be unique for the release, customization, community, and jcr domains:
- dbdomain.DbType
- dbdomain.DbName
- dbdomain.DbUrl
- dbdomain.DbSchema
If you use the same values for all four properties across the release, customization, community, and JCR domains, the database-transfer task fails because of ambiguous database object names. If DbUser, DbUrl, and DbPassword are not the same across domains, the value for DataSourceName must differ from the DataSourceName of the other domains. In other words, this value must be unique for the database domain.

Steps for transferring data to another supported database

If you are running a type 2 connection, before transferring data edit the db2cli.ini file. Failure to follow these steps will cause the database transfer to hang at the task action-process-constraints.
Note: If you are running a remote z/OS database, step b should be applied to the client side only.
1. Locate the file /home/db2inst1/sqllib/cfg/db2cli.ini
2. Add the following to the end of the file. Leave an empty line after ReturnAliases=0.
```
[COMMON]
DYNAMIC=1
ReturnAliases=0
```
Locate the following files and create a backup copy of each before changing any values:
- wp_profile_root/ConfigEngine/properties/wkplc.properties
- wp_profile_root/ConfigEngine/properties/wkplc_comp.properties
- wp_profile_root/ConfigEngine/properties/wkplc_dbtype.properties
Default values are listed in these files. Unless otherwise noted, all values are of type alphanumeric text string. Print out the steps below for reference before modifying the properties files. Make sure to enter the appropriate values for each instance of each property. In wkplc_comp.properties, most properties are repeated for each domain.
Use a text editor to open the properties file wkplc_comp.properties and modify the values to correspond to your environment.
1. For dbdomain.DbType, type db2.
2. For dbdomain.DbName, type the name of the WebSphere Portal Express domain database and schema.
  Note: This value is also the database element in the dbdomain.DbUrl property.
3. For dbdomain.DbSchema, type the schema name of the database domain.
  Note: Follow the documentation of the target database management system in order to define a valid schema name as restrictions apply for some database management systems.
4. For dbdomain.DataSourceName, type the name of the data source that WebSphere Portal Express uses to communicate with its databases.
5. For dbdomain.DbUrl, type the database URL used to access the WebSphere Portal Express database with JDBC. The value must conform to the JDBC URL syntax specified by the database.
  Note: The database element of this value should match the value of DbName.
  Recommended value:
  - Type 2: { jdbc:db2:wpsdb }
  - Type 4: { jdbc:db2://YourDatabaseServer:port/wpsdb:returnAlias=0; }
6. For dbdomain.DbUser, type the user ID for the database administrator.
7. For dbdomain.DbPassword, type the password for the database administrator.
8. For dbdomain.DBA.DbUser, type the database administrator user ID for privileged access operations during creation of the database.
9. For dbdomain.DBA.DbPassword, type the database administrator password for privileged access operations during creation of the database.
Save and close the file.
Update the following properties in the file wkplc_dbtype.properties.
1. For db2.DbDriver, type the name of the JDBC driver class.
  Recommended value:
  - Type 2: COM.ibm.db2.jdbc.app.DB2Driver
  - Type 4: com.ibm.db2.jcc.DB2Driver
2. For db2.DbLibrary, type the directory and name of the .zip or .jar file that contains the JDBC driver class.
3. For db2.JdbcProviderName, type the name of the JDBC provider that WebSphere Portal Express uses to communicate with its databases.
  Recommended value: wpdbJDBC_db2
Save and close the file.
Update the following property in the file wkplc.properties.
1. For WasPassword, type the password for the WebSphere Application Server security authentication used in your environment.
Save and close the file.
Open a command prompt and change to the directory wp_profile_root/ConfigEngine.
Enter the following commands to validate configuration properties.
- ConfigEngine.bat validate-database-driver -DTransferDomainList=release,customization,community,jcr,feedback,likeminds
- ConfigEngine.bat validate-database-connection -DTransferDomainList=release,customization,community,jcr,feedback,likeminds
From the same command prompt as the previous steps, change to the directory wp_profile_root/bin.

Stop both WebSphere Application Server and the WebSphere Portal Express server:

Option	Description
WebSphere Application Server	`stopServer.bat server1 -user admin_userid -password admin_password`
WebSphere Portal Express	`stopServer.bat WebSphere_Portal -user admin_userid -password admin_password`

Transfer the database:
1. Change to the directory wp_profile_root/ConfigEngine.
2. Enter the following commands:
  ConfigEngine.bat database-transfer -DTransferDomainList=release,customization,community,jcr,feedback,likeminds
3. After running this task, a message is added to the log files to verify that this task was successful. Check the log files. If the configuration fails, verify the values in the wkplc.properties, wkplc_comp.properties, and wkplc_dbtype.properties files and then repeat this step.
After transferring the database tables, perform a reorg check to improve performance. Perform this step for each database alias in the property file.
1. Connect to a database with the following command:
```
db2 connect to database_alias user db2admin_userid using password
```
  Note: Additional options might be required if additional security has been installed. Refer to DB2 Universal Database commands by example for links to the command reference.
2. After it is connected, run the following command from the DB2 prompt: db2 reorgchk update statistics on table all > xyz.out
3. Look in the reorg column for entries marked with a * (star or asterisk) in the file xyz.out. For each line with a *, note the tablename and run the following command for each tablename:
```
db2 reorg table tablename
db2 terminate
db2rbind database_name -l db2rbind.out -u db2_admin -p password
```
4. The output file db2rbind.out is only created when there is an error for the db2rbind command.
Change to the directory wp_profile_root/bin.
Enter the following command to start the WebSphere Portal Express server: startServer WebSphere_Portal -profileName profile_root