IBM Support

How do I use Warehouse Manager Java External trigger on iSeries ?

Technote (FAQ)


DB2 Warehouse Manager contains Java External Trigger components which gives user the ability to run predefined warehouse steps outside DWC. This utility provides the option to run a batch of processes in the background either from command line or from an user defined program. Java External Trigger comes with External Trigger Server and External Trigger Client components. The server runs on Windows or AIX system where warehouse server can be run.


To run the server on windows, the LPP for Java is required on as/400 and you must follow these steps:

  1. Set JAVA_HOME=<server's Java root directory>
    set JAVA_HOME=c:\program files\ibm\sqllib\java
  2. Set SQLTOOLS = <server's sqllib\tools directory>
    set SQLTOOLS=c:\program files\ibm\sqllib\tools
  3. set CLASSPATH = .;%SQLTOOLS%\db2XTrigger.jar;%JAVA_HOME%\Common.jar;%JAVA_HOME%\jdk\jre\lib;%JAVA_HOME%\jdk\lib;%SQLTOOLS%\db2vwcom.jar

    *NOTE: on Unix, make sure it's Common.jar - case sensitive
    (export CLASSPATH=.:$SQLTOOLS/db2XTrigger.jar:$JAVA_HOME/Common.jar:$JAVA_HOME/jdk/jre/lib:$JAVA_HOME/jdk/lib:$SQLTOOLS/db2vwcom.jar)
  4. java db2_vw_xt.XTServer 11004
    This should start the External server on port 11004.

Now, to setup the client on iSeries , follow these steps:
  1. Make sure these two files exist in the directory /qibm/userdata/os400/sqllib/function/JET
  2. Open the Qshell Interpreter on iSeries using the command QSH
  3. Set the CLASSPATH using the command :
    ( export -s CLASSPATH=.:/qibm/UserData/OS400/SQLLib/Function/JET/db2XTrigger.jar:/qibm/UserData/OS400/SQLLib/Function/JET/Common.jar )
  4. Run java db2_vw_xt.XTClient to test

    The command itself shows the parameters list if run on command line. Please refer DWC admin guide for the usage of these utility. These guides are available on-line at:

Document information

More support for: DB2 Warehouse Manager
External Trigger

Software version: 8.1, 8.2

Operating system(s): IBM i

Software edition: All Editions

Reference #: 1172855

Modified date: 29 July 2011

Translate this page: