Search Tips   |   Advanced Search

AIX stand-alone: Change DB2 driver types

WebSphere Portal requires the use of either the IBM DB2 Legacy JDBC driver in type 2 mode or the IBM DB2 Universal JDBC driver in type 4 mode when connecting to DB2.

Before beginning, ensure that the following conditions are met:

If WebSphere Portal is installed on the same machine as the DB2 server and you switch from a JDBC Type 4 connection to a JDBC Type 2 connection, verify that you have created the alias names for the DB2 databases as described in Create remote databases and that the alias names are specified for the databases in the file wkplc_dbdomain.properties.

When switching from a JDBC Type 2 connection to a JDBC Type 4 connection, remove the database alias names and refer to the databases directly. This is required because of a limitation in the DB2 Universal JDBC driver.

  1. cd WP_PROFILE/ConfigEngine

  2. Export the DB2 user profile that created when installing DB2 onto the administrative user . This command exports the DB2 user's profile onto the administrative user so that they can access the DB2 utilities.

      . /home/db2inst1/sqllib/db2profile

    ...where db2inst1 represents the database instance

    Complete this step before running database tasks and before enabling security.

  3. Validate configuration properties...

      ./ConfigEngine.sh validate-database -DWasPassword=foo

    Add -DTransferDomainList to the validating task to specify the domains to validate; for example...


    To validate all domains, do not specify this parameter.

  4. cd WP_PROFILE/bin

  5. Stop the WebSphere_Portal server:

      ./stopServer.sh WebSphere_Portal -username wpadmin -password foo

  6. cd WP_PROFILE/ConfigEngine

  7. 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.sh connect-database -Drelease.DbPassword=foo -Dcustomization.DbPassword=foo -Dcommunity.DbPassword=foo -Djcr.DbPassword=foo -Dfeedback.DbPassword=foo -Dlikeminds.DbPassword=foo -DWasPassword=foo

  8. cd WP_PROFILE/bin

  9. Start the WebSphere Portal server.

Parent: AIX stand-alone: Type 2 driver support