Administrator

Enabling the DB2 JDBC Driver

To use an IBM DB2 database, enable the JDBC driver that is installed with SMS Builder.

Prerequisites

Configure the DB2 database.

Procedure

  1. Open the <SMSBUILDER_HOME>/conf/cfgbackupservice.dsprovider.properties file.
  2. Remove the comment indicators from the DB2 configuration, and enter the password you created for the mwiz2 user:
    • If the password is encrypted, replace XXX with the encrypted password.
    • If the password is plain text, replace {enc}XXX with the password.
    # DB2   
    driverClassName=com.ibm.db2.jcc.DB2Driver   
    url=jdbc:db2://localhost:60000/brandmob   
    username=mwiz2   
    password={enc}XXX   
    validationQuery=select 1 from sysibm.sysdummy1 
  3. Comment out the SQL Anywhere configuration, and save the file.