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

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

• 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.

See also