ttXactIdGet

Description

Displays transaction ID information for interpreting lock messages. The two result columns of ttXactIdGet are used in combination to uniquely identify a transaction in a data store. Taken individually, the columns are not interesting. The result should only be used to correlate with other sources of transaction information. The numbers may not follow a strict pattern.

Required privilege

This procedure requires no privilege.

Syntax

ttXactIdGet()

Parameters

ttXactIdGet has no parameters.

Result set

ttXactIdGet returns the result set:

Column	Type	Description
`xactID`	TT_INTEGER	Connection ID.
`counter`	TT_BIGINT	An increasing number that is used to discriminate successive transactions of the same Transaction Id.

Example

Command > automcommit 0;
Command > call ttXactIdGet;
<2,11>
1 row found
Command > commit;
Command > call ttXactIdGet
<3, 12>
1 row found

Note

The output correlates to the values printed in lock error messages and ttXactAdmin lock information output.