A. Building CICS/6000 Programs on UNIX : How You Configure Multiple Resource Manager Instances
 
Share this page                  
How You Configure Multiple Resource Manager Instances
Ingres DTP supports access to multiple resource manager instances (RMIs) from a single CICS/6000 application server (AS). Follow these guidelines for multiple RMI support:
Configure each RMI as a separate XAD definition. For more information on configuring multiple RMIs, refer to the CICS/6000 Customization and Operation Guide.
In an Ingres DTP application that accesses multiple RMIs, use the SQL set connection statement to specify the RMI to which the application requires access.
The example code below shows an Ingres DTP application with two RMIs, identified as CONN1 and CONN2. The code updates both RMIs.
exec sql set connection 'conn1';
exec sql update account
 set balance = balance + :bal
 where acct = :acct;
exec sql set connection 'conn2';
exec sql update account
 set balance = balance - :bal
 where acct = :acct;
exec cics syncpoint;