Background on IBM DB2

IBM DB2 comes in three flavors : 

  • DB2 for LUW (Linux, Unix, Windows)
  • DB2 for i (formerly known as DB2 for i5/OS)
  • DB2 for z/OS

Each flavor comes with its own peculiarities. All of them work with the IBM native JDBC drivers  (db2jcc4.jar) and (db2jcc.jar) and have their own catalog tables:

  • DB2 for LUW - Does not need a license file for using IBM native driver
  • DB2 for i -  Requires a license file to use IBM native driver
  • DB2 for z/OS -  Requires a license file to use IBM native driver
IBM native JDBC driver requires the IBM JVM for connecting to DB2 although in some cases it works for IBM DB2 for LUW using the Oracle JVM.

Prerequisites
  • IBM native JDBC drivers  (db2jcc4.jar)  and  (db2jcc.jar) along with the license jar files
  • IBM JVM 8 or later. IBM JVM is usually part of IBM Data Studio and IBM Development Kit
  • Apache Tomcat 8 or later. It can be downloaded from
    https://tomcat.apache.org/download-80.cgi

Setup ETL Validator
The steps below are intended for users trying to setup ETL Validator for connecting to one of the flavors of IBM DB2
  • Install ETL Validator Client if you are planning to host the repository / workschema in an Oracle database. If you want to use the embedded PostgreSQL repository, install ETL Validator Complete
  • Install Apache Tomcat 8 or later. During the installation, select the IBM JVM when prompted


  • Deploy the ETL Validator Server war files listed below. These files are part of the ETL Validator Server download and are also found in the embedded tomcat that is part of ETL Validator Complete (C:\app\Datagaps\ETLValidator\Server\apache-tomcat\webapps) : 
    • ETLValidatorServer.war
    • ETLValidatorService.war

      To deploy just copy the above two war files into the <CATALINA_HOME>/webapps directory. The war files should automatically get extracted after they are placed. If not, restart tomcat.
  • Copy the IBM JDBC driver files to <CATALINA_HOME>/webapps/ETLValidatorServer/WEB-INF/lib folder and restart Tomcat service from the Windows Services

Upgrading ETL Validator Server 
  • Stop Apache Tomcat Service from the services window
  • Navigate to <CATALINA_HOME>/webapps and delete the folders 'ETLValidatorServer' and 'ETLValidatorService'
  • Copy the latest ETL Validator server war files to <CATALINA_HOME>/webapps (replace any existing war files)
  • Start Apache Tomcat Service from the services window. Notice that ETLValidatorServer.war file is expanded automatically during the tomcat restart
  • Copy the IBM JDBC driver files to <CATALINA_HOME>/webapps/ETLValidatorServer/WEB-INF/lib folder
  • Restart Apache Tomcat Service from the services window