Xill DB2 plugin

This package contains everything you need to access a DB2 database

Setting up the environment

  1. Make sure you have access to a DB2 database Server.
  2. Install Xill IDE.
  3. Extract the plugin-db2-1.0.0-zip-with-dependecies.zip file in temporary directory. Do not unpack it in <user-path>/.xillio/xill/3.0/plugins. This will corrupt the loading of the plugin.

Configuring for Windows

  1. Find the directory where the file Xill IDE.cfg is found.
  2. Copy plugin-db2-1.0.0/bin/db2jcc4-10.1.jar and plugin-db2-1.0.0/bin/plugin-db2-1.0.0.jar from the extracted zip file to the lib inside this directory.
  3. Edit the Xill IDE.cfg configuration file and look up the line starting with app.classpath=....
    Add the following entries at the end of this line ;lib/db2jcc4-10.1.jar;lib/plugin-db2-1.0.0.jar
    Please note the semi colons that are used as delimiter for the classpath.
  4. Start Xill IDE and check if the Db2 package is present.

Configuring for OSX

  1. Find the directory where the file Xill IDE.cfg is found (probably /Applications/Xill IDE.app/Contents/Java/Xill IDE.cfg).
  2. Copy plugin-db2-1.0.0/bin/db2jcc4-10.1.jar and plugin-db2-1.0.0/bin/plugin-db2-1.0.0.jar from the extracted zip file to the lib inside this directory.
  3. Edit the Xill IDE.cfg configuration file and look up the line starting with app.classpath=....
    Add the following entries at the end of this line :lib/db2jcc4-10.1.jar:lib/plugin-db2-1.0.0.jar
    Please note the colons that are used as delimiter for the classpath.
  4. Start Xill IDE and check if the Db2 package is present.

Configuring for Linux

  1. Find the directory where the file XillIDE.cfg is found.
  2. Copy plugin-db2-1.0.0/bin/db2jcc4-10.1.jar and plugin-db2-1.0.0/bin/plugin-db2-1.0.0.jar from the extracted zip file to the lib inside this directory.
  3. Check the permission of these two files to be at least read for the user using Xill IDE.
  4. Edit the XillIDE.cfg configuration file and look up the line starting with app.classpath=....
    Add the following entries at the end of this line :lib/db2jcc4-10.1.jar:lib/plugin-db2-1.0.0.jar
    Please note the colons that are used as delimiter for the classpath.
  5. Start Xill IDE and check if the Db2 package is present.