xact_owner_instance

Description

(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

An XA transaction “txn_name” is running on instance “ase1”.

select xact_owner_instance(txn_name)
-------
    1

Example 2

An XA transaction “txn_name” is not running.

select xact_owner_instance(txn_name)
-------
  NULL

Usage

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

Any user can execute xact_owner_instance.

See also

Functions xact_connmigrate_check