Configuring BWAgent for DB2 and TIBCO FTL®

The BWAgent can be configured to use DB2 database with TIBCO FTL for transport.

Note: Use of TIBCO FTL with ActiveMatrix BusinessWorks for configuring BWAgent and for configuring group provider for engine does not require TIBCO FTL licenses.
Note: The database name must be unique per agent network if multiple networks share the same physical database.
Before you begin
  • Install and configure TIBCO FTL on the same machine that you have installed ActiveMatrix BusinessWorks 6.x on. For more information, see the "Setting Up TIBCO FTL® for BWAgent Transport" topic in the TIBCO ActiveMatrix BusinessWorks™ Installation guide.
    Important: For the version of TIBCO FTL that is supported with the version of ActiveMatrix BusinessWorks 6.x, see the ActiveMatrix BusinessWorks readme.
  • Download the latest DB2 server package from their official website and install DB2. Configure the server configuration by following the prompts in the DB2 Server Configuration wizard.
  • Download the latest JDBC driver and connector JAR files for DB2 to the BW_HOME\config\drivers\shells\jdbc.db2.runtime\runtime\plugins\com.tibco.bw.jdbc.datasourcefactory.db2\lib folder for Windows or the ${BW_HOME}/system/lib folder for Unix.
  • Install the DB2 driver by running the command bwinstall db2-driver from the /bin folder.
    Procedure
  1. Log in to DB2 and create database by running the following command:
    CREATE DATABASE <database name> USING CODESET UTF-8 TERRITORY US COLLATE USING SYSTEM PAGESIZE 16384
    Note: Set the page size to 16K (16384) or higher.
  2. Stop the BWAgent if it is running.
  3. Open the bwagent_ftl.json file in BW_HOME\config (Windows) or ${BW_HOME}/config (Unix).
  4. Update the following properties for your environment:
    Property Name DB2 Value
    dbtypedb2
    dbdriver com.ibm.db2.jcc.DB2Driver
    dbconnectionurl jdbc:db2://localhost:50000/bwadmindb
    dbuserbwuser
    dbpasswordbwuser
  5. Run the BWAdmin config command with the -cf option to push the changes from the JSON file to the bwagent.ini file. 
    BW_HOME\bin>bwadmin config -cf ../config/bwagent_ftl.json agent
  6. Restart the BWAgent.