System and method for supporting resource manager (RM) instance awareness in a transactional environment

摘要

A system and method can support transaction processing in a transactional environment. A transactional server operates to receive resource manager (RM) instance information from a data source that is associated with one or more RM instances, wherein the received instance information allows the transactional server to be aware of which RM instance that the transactional server is currently connected to. Furthermore, the transactional server operates to save the received instance information into one or more tables that are associated with the transactional server. Then, the transactional server can process a global transaction based on the instance information saved in the one or more tables.

主权项

1. A method for supporting transaction processing in a transactional system comprising:
a plurality of transactional servers including a plurality of transaction managers, and a plurality of resource manager (RM) instances for managing access to a plurality of databases, the method comprising: providing a server table in a shared memory accessible from said plurality of transactional servers, said server table comprising a server table entry for each of said plurality of transactional servers and an instance identifier for each of said plurality of transactional servers, receiving at each of the plurality of transactional servers RM instance information indicative of which RM instance of the plurality of RM instances said each of the plurality of transactional servers is currently connected to; saving the received instance information from each of the plurality of transactional servers into the instance identifier associated with said each of the plurality of transactional servers in said server table in said shared memory accessible from said plurality of transactional servers; allowing transactional servers participating in global transactions to access said server table to obtain instance information identifying which of the plurality of transactional servers are connected to which RM instance, and coordinate said global transactions based on said instance information; and in response to changes in connections between said each of the plurality of transactional servers and said plurality of databases, updating the instance identifiers associated with said each of the plurality of transactional servers in said server table in said shared memory.