Change driver types

 

+

Search Tips   |   Advanced Search

 

Before you begin

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

2. Set values in wkplc_comp.properties and wkplc_dbtype.properties for the DB2 drivers that you are switching to.

3. In wkplc_comp.properties set each Domain.DbUrl property...

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

   In wkplc_dbtype.properties set db2.DbLibrary...

      # 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
   
   
   

4. In wkplc_dbtype.properties set db2.DbDriver...

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

   Prerequisites...

   1. Install DB2
   2. Create users
   3. Create remote databases
   4. Modify database properties
   5. Configure WebSphere Portal to use DB2
   6. Configure DB2 for large file handling in WCM

Procedure

1. Validate configuration properties.
   cd profile_root/ConfigEngine
   ./ConfigEngine.bat validate-database-driver -DTransferDomainList=release,customization,community,jcr,feedback,likeminds -DWasPassword=wpsadmin
   ./ConfigEngine.bat validate-database-connection -DTransferDomainList=release,customization,community,jcr,feedback,likeminds -DWasPasswordwpsadminpassword

2. Stop both WAS and the WebSphere Portal server:
   profile_root/bin
   ./stopServer.bat server1 -username admin_userid -password admin_password
   ./stopServer.bat WebSphere_Portal -username admin_userid -password admin_password

3. Change from one supported driver to the other. Include only domains that require the switch.

   cd profile_root/ConfigEngine.
   ./ConfigEngine.bat connect-database -Drelease.DbPassword=wpsadmin -Dcustomization.DbPassword=wpsadmin -Dcommunity.DbPassword=wpsadmin -Djcr.DbPassword=wpsadmin -Dfeedback.DbPassword=wpsadmin -Dlikeminds.DbPassword=wpsadmin -DWasPassword=password

4. Start the WebSphere Portal server:
   cd profile_root/bin
   ./startServer.bat WebSphere_Portal

Parent topic:

Configure WebSphere Portal to use DB2

Previous topic:

Configure DB2 for large file handling in WCM