When trying to connect to some DB2 versions from the AE, you might encounter an error like the following:
Could not connect to database […] the version of the IBM Universal JDBC driver in use is not licensed for connectivity to QDB2 databases. To connect to this server, please obtain a licensed copy of the IBM DB2 Universal Driver for JDBC and SQLJ. An appropriate license file db2jcc_license_*.jar for this target platform must be installed to the application class path. Connectivity to QDB2 databases is enabled by […] the following license file: db2jcc_license_cisuz.jar
The specific file named (which may vary depending on the version) needs to be obtained from the customer's DB admin. (It can typically be found in C:\Program Files\IBM\SQLLIB\java.) It should be placed on the appliance in the following location (which is where the existing JDBC drivers are):
- or -
You should probably set the permissions and ownership/group to the same as the other .jar files in this folder (755, mdw/mdw). Next, the application.xml file in:
- or -
needs to be modified to add a reference to the file. You can copy and modify an existing entry, to look like the following (for the specific file above):
<module> <java>lib/db2jcc_license_cisuz.jar</java> </module>
Finally, the appliance can be rebooted, or you can simply restart the MDW service with the following command:
service webalo-md restart
You should then be able to get a successful test connection to the DB2 server. Make sure the port specified is actually the one they use -- our default is not always correct.
Presumably, installing a JDBC driver for some database that is not supported by default (e.g. MySQL) would involve similar steps, but I haven't been through that yet.