Portal, V6.1

---

 

Change driver types

WebSphere Portal requires either JDBC Type 2 or Type 4 drivers. This section provides information on how to switch from one driver type to the other. Before you begin, ensure that the following conditions are met:

• The WebSphere Portal database has been successfully transferred to DB2 using the database-transfer configuration task.

• The files wkplc_comp.properties and wkplc_dbtype.properties have been modified to set the correct values for the DB2 drivers that you are switching to:In the file wkplc_comp.properties set each <Domain>.DbUrl property using the following formats:

  # db2 (type 2):        { jdbc:db2:wpsdb }
  # db2 (type 4):        { jdbc:db2://<YourDatabaseServer>:50000/wpsdb:returnAlias=0; }
  

  In the file wkplc_dbtype.properties set the db2.DbLibrary property using the following format:

  # For DB2 Type 2 driver use <SQLLIB>/java/db2java.zip
  # For DB2 Type 4 driver use <SQLLIB>/java/db2jcc.jar;<SQLLIB>/java/db2jcc_license_cu.jar
  

  In the file wkplc_dbtype.properties set the db2.DbDriver property using the following format:

  # For DB2 Type 2 driver use COM.ibm.db2.jdbc.app.DB2Driver
  # For DB2 Type 4 driver use com.ibm.db2.jcc.DB2Driver
  

Prerequisites

Installing DB2

Create users

Creating remote databases

Modifying database properties

Configure WebSphere Portal to use DB2

1. Open a command prompt and change to the directory WP_PROFILE/ConfigEngine.

2. 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

3. From the same command prompt as the previous steps, change to the directory WP_PROFILE/bin.

4. Stop both WAS and the WebSphere Portal server:

   Option	Description
   WAS	stopServer.bat server1 -username adminid -password passwd
   WebSphere Portal	stopServer.bat WebSphere_Portal -username adminid -password passwd

5. Change to the directory WP_PROFILE/ConfigEngine.

6. To change from one supported driver to the other, run the following task to connect the database, including only the domains that require the switch.

   ConfigEngine.bat connect-database -Drelease.DbPassword=wpsadmin -Dcustomization.DbPassword=wpsadmin -Dcommunity.DbPassword=wpsadmin -Djcr.DbPassword=wpsadmin -Dfeedback.DbPassword=wpsadmin -Dlikeminds.DbPassword=wpsadmin
   

7. Change to the directory WP_PROFILE/bin.

8. Start the WebSphere Portal server: startServer.bat WebSphere_Portal

 

Parent topic

Configure WebSphere Portal to use DB2

 

Previous topic:

Configure WebSphere Portal to use DB2

---