Preparing the Netezza Environment

In order to use the Adapter for Netezza, you must install the Netezza driver, set its CLASSPATH value before server startup, and ensure that the JSCOM3 service is running.

Set Up the Environment on Windows and UNIX

    Procedure
  1. Identify the location of the Netezza driver files by adding them to the environment variable CLASSPATH before server startup.
    Note: If Db2 v11 and Netezza are installed on the same machine, the Netezza jar file must be listed first in the CLASSPATH.

    For example, to set a UNIX or IBM i location for Netezza JDBC driver files: 

    CLASSPATH=/rdbms/netezza_jar/netezza-jdbc.jar: 
/rdbms/netezza_jar/bcprov-jdk14-122.jar:$CLASSPATH
export CLASSPATH

    Similarly, on Windows, you would issue the command:

    set CLASSPATH=c:\usr\driver_files\<netezza_jdbc_driver_files>;%CLASSPATH%

    See the Netezza documentation for specific file names and their locations.

    Note that if you run the server workspace as a Windows service, you must set the CLASSPATH as a system-wide environment variable.

    Similarly, on UNIX, to ensure that the variable is set before server startup, add the CLASSPATH setting in your UNIX profile.

  2. Start (or restart) the server.

    (Note that you also need to restart the server if the driver has changed.)

  3. Verify that the JSCOM3 service is active by issuing the following command in the server workspace 
    edastart -show

    and check the special services section displays "JSCOM3 active".

    If the JSCOM3 service is not active, a "fail to start" message will typically also be in the server's EDAPRINT. To resolve the problem, review the JDBC listener requirements in the chapter for your operating system in the ibi™ WebFOCUS® Reporting Server Installation manual.