Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Chapter 3 Configuring and Operating : Steps to Implement Fail Safe Processing

Steps to Implement Fail Safe Processing
Step 1: Define an External Transaction Table
To implement Fail Safe level‑1 processing, you must define an external DBMS table similar to the one shown below.
The sample Oracle table definition below shows Oracle terms, and that terms vary from one DBMS to another. The table in the example below holds a maximum of one record for each combination of a Gateway and Data Object Broker.

 
 
Security Requirements
During Fail Safe level‑1 processing, the Gateway inserts or replaces this table. If the Gateway is running with Security Level=1, this table is updated under the authorization of the TIBCO Object Service Broker client/session user ID. All users that need to access the external DBMS through the Gateway and run transactions that update both TDS and external data must have read and write access to this table.
Step 2: Define the Gateway Fail Safe Startup Parameters
Ensure that the gateway startup parameters listed below are defined as follows:
Set FSTABLENAME to the name of the external transaction table you defined in the external DBMS. This name is used “as is”, that is, no qualifier (catalog) and owner (schema) are prepended to it so it can contain those if needed, for instance “pubs.dbo.ostarfs.”
Set TRXDB to the ODBC data source or Oracle SID denoting the database where you defined the transaction table that you plan to have participate in Fail Safe processing.

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved