Updating the Database Schema to Enable bwagent to Use Database with TIBCO Enterprise Message Service

If you are upgrading from TIBCO ActiveMatrix BusinessWorks™ 6.3.1™, or from TIBCO ActiveMatrix BusinessWorks™ 6.3.2, to a higher version of the software, refer to the following sections for instructions on how to update the database schemas for PostgreSQL, Microsoft SQL, Oracle, DB2, and MySQL.

PostgreSQL, Microsoft SQL, Oracle, or DB2

If bwagent has been configured to use PostgreSQL, Microsoft SQL, Oracle, or DB2 with TIBCO Enterprise Message Service (EMS) for persistence and transport, update the database schema by following these steps:
  1. Back-up your data in the commandHistory table.
  2. Execute the following command to drop the table. 
    drop table commandHistory;
  3. Restart the bwagent.

MySQL

If bwagent has been configured to use MySQL with TIBCO Enterprise Message Service (EMS) for persistence and transport, update the database schema by following these steps:
  1. Execute the following command to alter the table. 
    ALTER TABLE commandHistory MODIFY commandId int NOT NULL AUTO_INCREMENT;
  2. Restart the bwagent.