Transaction Identification in systransactions

SAP ASE stores transaction names in a column of varchar(255) to accommodate the length and format of transaction names supplied by different distributed transaction protocols.

In the X/Open XA protocol, for instance, distributed transactions are assigned a transaction name consisting of both a global transaction ID (gtrid) and a branch qualifier. Within SAP ASE, this information is combined in the xactname column of the systransactions table.

systransactions.xactname stores the names of both externally-created distributed transactions (defined by an X/Open XA transaction manager or MSDTC) and local server transactions. Clients can assign any name to local transactions, within the confines of the varchar(255) column. Similarly, external transaction managers can use a variety of different formats to name a distributed transaction.