xact_owner_instance

(Cluster environments only) Returns the instance ID on which the distributed transaction is running.

Syntax

xact_owner_instance(“txn_name”)

Parameters

txn_name – is a transaction ID.

Examples

Example 1 – Shows an XA transaction “txn_name” running on instance “ase1”:
```
select xact_owner_instance(txn_name)
```
```
-------
    1
```
Example 2 – Shows an XA transaction “txn_name” not running:
```
select xact_owner_instance(txn_name)
```
```
-------
  NULL
```

Usage

xact_owner_instance returns:

The instance ID of the instance running the transaction, or
Null, if the transaction is not running

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

Any user can execute xact_owner_instance.

Parent topic: Transact-SQL Functions

Related reference

xact_connmigrate_check

Created May 28, 2014. Send feedback on this help topic to Technical Publications: pubs@sap.com