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-23)

type

int

Value indicating the type of transaction (see Table 1-24)

coordinator

int

Value indicating the coordination method or protocol (see Table 1-25)

state

int

Value indicating the current state of the transaction (see Table 1-26)

connection

int

Value indicating the connection state (see Table 1-27)

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 1-23: systransactions failover column values

failover value

Failover state

0

Resident Tx

1

Failed-over Tx

2

Tx by Failover-Conn

Table 1-24: systransactions type column values

type value

Transaction type

1

Local

3

External

98

Remote

99

Dtx_State

Table 1-25: systransactions coordinator column values

coordinator value

Coordination method or protocol

0

None

1

Syb2PC

2

ASTC

3

XA

4

DTC

Table 1-26: 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-27: systransactions connection column values

connection value

Connection state

1

Attached

2

Detached