Enabling the DB2 JDBC Driver

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

Prerequisites

Configure the DB2 database.

Task

Open the BRAND_HOME/conf/cfgbackup/service.dsprovider.properties file.
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 
```

Comment out the Derby configuration, and save the file:

# DERBY EMBEDDED  – For development and Testing only!!!!!   
#driverClassName=org.apache.derby.jdbc.EmbeddedDriver   
#url=jdbc:derby:mwiz2   
#username=mwiz2   
#password=sql   
#validationQuery=select 1 from sysibm.sysdummy1