Configuring Transaction Resources

SAP ASE provides a common interface to support both local server transactions and external transactions that are coordinated by distributed transaction protocols.

Distributed transaction protocol support is provided for X/Open XA, MSDTC, and native SAP ASE transaction coordination services.

SAP ASE manages all transactions as configurable server resources, and the system administrator can configure the total number of resources available in a given server. Client tasks that access SAP ASE in an X/Open XA environment can also suspend and join threads to transaction resources as needed.

This section describes how to determine and configure the total number of transaction resources available to SAP ASE.

• Calculating the Number of Required Transaction Descriptors
  SAP ASE uses the transaction descriptor resource to manage transactions within a server. A transaction descriptor is an internal memory structure that SAP ASE uses to represent a transaction.
• Setting the Number of Transaction Descriptors
  Once you have determined the number of transaction descriptors to use in your system, use sp_configure to set the value of txn to pss ratio.