Chapter 1: System Tables

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 1-24)
type	int	Value indicating the type of transaction (see Table 1-25)
coordinator	int	Value indicating the coordination method or protocol (see Table 1-26)
state	int	Value indicating the current state of the transaction (see Table 1-27)
connection	int	Value indicating the connection state (see Table 1-28)
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
xactname	varchar(255) null	Transaction name or XID
srvname	varchar(30) null	Name of the remote server (null for local servers)
nodeid	tinyint null	Reserved for future use

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

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

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

**Table 1-27: 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 1-28: systransactions connection column values**
connection value	Connection state
1	Attached
2	Detached

View this book as PDF