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 TIBCO 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.

Prerequisites

  • 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 DB2 server package 10.5 from http://www-01.ibm.com/software/data/db2/linux-unix-windows/downloads.html and install DB2. Configure the server configuration by following the prompts in the DB2 Server Configuration wizard.
  • Download the following 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:
    • db2jcc4.jar from http://www-01.ibm.com/support/docview.wss?uid=swg21363866.
  • 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 executing 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 located in BW_HOME\config (Windows) or ${BW_HOME}/config (Unix).
  4. Update the following properties for your environment:
    Property Name DB2 Value
    dbtype db2
    dbdriver com.ibm.db2.jcc.DB2Driver
    dbconnectionurl jdbc:db2://localhost:50000/bwadmindb
    dbuser bwuser
    dbpassword bwuser
  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.