Web Search
TIBCO Service Gateway™ for DB2
Important Information
Preface
Related Documentation
Typographical Conventions
Connecting with TIBCO Resources
Installing Service Gateway for DB2
Introduction
Preparing for Installation
Distribution Media and Contents
Uploading the Software
Installing the Software
Installing on a Remote Host
Binding the Gateway Plan
Requirements for Accessing DB2 Using Static SQL
Specifying the Gateway Plan to TIBCO Object Service Broker
Implementing Security
Specifying Gateway Parameters
Startup Prerequisites
Starting the Gateway
Shutting Down the Gateway
Installation Verification
Operating Service Gateway for DB2
Defining TIBCO Object Service Broker DB2 Tables
Gateway Parameters
Operations
Connecting the Gateway to a Windows, or Solaris Data Object Broker
Using Static SQL
Why Use Static SQL?
Task A: Log DB2 Accesses
Task B: Prepare to Generate Static SQL
Task C: Generate Static SQL Using the @STATICSQL Tool
Task D: Manage Warning and Error Messages from @STATICSQL
Task E: Assemble the Static SQL Handler
Task F: Link the Static SQL Handler
Task G: Bind the DB2 Gateway Plan with Static SQL
Task H: Update the Gateway Startup JCL
Static SQL Usage
Managing DB2 Data Definitions
Accessing DB2 Data from TIBCO Object Service Broker
Task A Choose a Method to Obtain the DB2 Table Definition
Task B Invoke the Table Definer
Task C Select a DB2 Table or Stored Procedure
Task D Select DB2 Columns
Task E Change the Defaults if Necessary
Effects of DB2 Column Selection on DB2 Processing
Processing Data
Accessing TIBCO Object Service Broker DB2 Tables
Behavior of the Gateway
Documenting DB2 Tables
Using the Documentation Screen