systransactions

master database only

Description

systransactions contains information about Adaptive Server transactions, but it is not a normal table. Portions of the table are built dynamically when queried by a user, while other portions are stored in the master database. Updates to the dynamically-built columns of systransactions are not allowed.

Columns

The columns for systransactions are:

Name	Datatype	Description
xactkey	binary(14)	Unique Adaptive Server transaction key
starttime	datetime	Date the transaction started
failover	int	Value indicating the transaction failover state (see Table 12-21)
type	int	Value indicating the type of transaction (see Table 12-22)
coordinator	int	Value indicating the coordination method or protocol (see Table 12-23)
state	int	Value indicating the current state of the transaction (see Table 12-24)
connection	int	Value indicating the connection state (see Table 12-25)
status	int	Internal transaction status flag
status2	int	Additional internal transaction status flags.
spid	smallint	Server process ID, or 0 if the process is detached
masterdbid	smallint	Starting database of the transaction
loid	int	Lock owner ID
namelen	smallint	Length of “xactname” below
xactname	varchar(255)	Transaction name or XID
srvname	varchar(30)	Name of the remote server (null for local servers)

Table 12-21 lists the values for the failover column:

**Table 12-21: systransactions failover column values**
failover value	Failover state
0	Resident Tx
1	Failed-over Tx
2	Tx by Failover-Conn

Table 12-22 lists the values for the type column:

**Table 12-22: systransactions type column values**
type value	Transaction type
1	Local
3	External
98	Remote
99	Dtx_State

Table 12-23 lists the values for the coordinator column:

**Table 12-23: systransactions coordinator column values**
coordinator value	Coordination method or protocol
0	None
1	Syb2PC
2	ASTC
3	XA
4	DTC

Table 12-24 lists the values for the state column:

**Table 12-24: systransactions state column values**
state value	Transaction state
1	Begun
2	Done Command
3	Done
4	Prepared
5	In Command
6	In Abort Cmd
7	Committed
8	In Post Commit
9	In Abort Tran
10	In Abort Savept
65537	Begun-Detached
65538	Done Cmd-Detached
65539	Done-Detached
65540	Prepared-Detached
65548	Heur Committed
65549	Heur Rolledback

Table 12-25 lists the values for the connection column:

**Table 12-25: systransactions connection column values**
connection value	Connection state
1	Attached
2	Detached