Distributing work across LRMs

The System Administrator and the application programmer together must agree on the number and names of LRMs that their Sybase XA environment includes.

The System Administrator configures the TM and Sybase XA configuration files accordingly. The application programmer invokes a particular LRM name within the application code to send a portion of a global transaction across that connection. The TM coordinates this distribution.

You can configure the Sybase XA environment for more connections than are actually used. That is, the XA configuration file may contain inactive entries.

For example, in a CICS environment with an Adaptive Server SYBXA_1, and an LRM connection connection_1,

• The Adaptive Server interfaces file includes server information:

  sybXA_1 query tcp ether groucho 6161
  

• The XA Configuration file includes connection and server information:

  ; lrm – Names the logical connection as seen by the application and the TP monitor.
  ; server – Names the physical server as found in the Sybase interfaces file.
  lrm=connection_1
  server=SYBXA_1
  

• The XAD File stanza for the LRM contains connection information:

  XAOpen="-Uuser1 -Ppassword1 -Nconnection_1"
  

• The application program contains transactions using connection_1.