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;