Change driver types

WebSphere Portal requires either JDBC Type 2 or Type 4 drivers. View the steps to switch from one driver type to the other. Before you begin, ensure that the following conditions are met:


Prerequisites

Installing DB2

Create users

Creating remote databases

Modifying database properties

Configure WebSphere Portal to use DB2

Configure DB2 for large file handling in Web Content Management

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

  2. Enter the following commands to validate configuration properties.

    ConfigEngine.bat validate-database-driver -DTransferDomainList=release,customization,community,jcr,feedback,likeminds -DWasPassword=password
    
    

    ConfigEngine.bat validate-database-connection -DTransferDomainList=release,customization,community,jcr,feedback,likeminds -DWasPassword=password
    
    

  3. From the same command prompt as the previous steps, change to the directory profile_root\bin.

  4. Stop both WAS and the WebSphere Portal server:

    Option Description
    WAS stopServer.bat server1-username admin_userid -password admin_password
    WebSphere Portal stopServer.bat WebSphere_Portal-username admin_userid -password admin_password

  5. cd profile_root/ConfigEngine.

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

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

  7. Change to the directory profile_root\bin.

  8. Enter the following command to start the WebSphere Portal server: startServer.bat WebSphere_Portal


Parent topic:

Set up a remote DB2 database


Previous topic:

Configure DB2 for large file handling in Web Content Management