ttXactIdGet

This procedure returns transaction ID information for interpreting lock messages. The two result columns of ttXactIdGet are used in combination to uniquely identify a transaction in a database. The first column represents the connection ID and the second column represents the increasing number of transactions for the same transaction ID. 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.

Usage in TimesTen Scaleout and TimesTen Classic

This procedure is supported in TimesTen Classic.

TimesTen Scaleout applications can call this built-in procedure.

In TimesTen Scaleout, this procedure runs locally on the element from which it is called.

Related Views

This procedure has these related views.

SYS.GV$XACT_ID

SYS.V$XACT_ID

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 distinguish successive transactions of the same transaction ID.

Examples

Command> autocommit 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.