1. Introduction
In This Guide
Audience
Special Considerations
General Restrictions
Syntax Conventions Used in This Guide
2. Introducing Ingres DTP
What Is Ingres DTP?
The X/Open DTP Standard
Transaction Processing Products
The X/Open DTP Model
XA Application Model
Ingres Star
Installation Requirements
3. Programming Ingres DTP Applications
Application Server Registration Routine
Open String Argument - Binding to Database Servers
How You Create an Ingres DTP Application
The Include Files
The xa_switch_t Structure
SQL Statement Restrictions
Transaction Context Restrictions
Environment Variables
Multiple Resource Manager Instances
Two Phase Commit
How Ingres DTP Applications Handle Errors
Error Messages
Database Access in Error Handlers
Error Codes
How to Design Your Application Server
4. Troubleshooting and Tuning Ingres DTP Applications
How You Obtain Trace and Error Information
Transaction Aborts
Performance Tuning
Session Cache Limit
Performance-Related Settings
A. Building CICS/6000 Programs on UNIX
How Ingres DTP Works with CICS/6000
How You Configure CICS/6000 with Ingres DTP
Step 1: Update the CICS/6000 Region Environment File
Step 2: Add the Ingres CICS User
Step 3: Register Databases with a CICS/6000 Region
Step 4: Build the Switch Load File
Step 5: Compile and Link the Switch Load File
How You Add COBOL Support
Step 1: Create an Exports List for the Ingres Library
Step 2: Modify the Link Script
Step 3: Rebuild the CICS/6000 COBOL Run Time System
How You Build CICS/6000 Applications
C Applications
COBOL Applications
How You Configure Multiple Resource Manager Instances
B. Building Encina Programs on UNIX
How You Build Programs for Encina
Step 1: Prepare the DCE Environment
Step 2: Register the Resource Manager Instances
Step 3: Create the Encina Code
Step 4: Compile and Link the Program
Step 5: Enable Tracing (Optional)
Step 6: Run the Program
Step 7: Verify the Results (Optional)
TRAN-C Considerations
C. Building Tuxedo Programs on UNIX
Process Architecture
Installation Requirements
How You Configure the Tuxedo System
Step 1: Modify the Resource Manager Definition File
Step 2: Build the TMS Server
How You Create a Tuxedo Application
Step 1: Build Application Servers
Step 2: Edit the Application Configuration File
Step 3: Edit the ENVFILE
How You Start and Shut Down Application Servers
How You Verify Server Startup
Application Development Guidelines
Placement of Transaction Demarcation Calls
Error Handling
Deadlock Handling
TP_COMMIT_CONTROL
Ingres 10S
TP_COMMIT_CONTROL