xact_connmigrate_check

Description

(Cluster environments only) Determines whether or not a connection can process an external transaction.

Syntax

xact_connmigrate_check(“txn_name”)

Parameters

txn_name

is a transaction ID. This parameter is optional.

Examples

Example 1

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

select xact_connmigrate_check("txn_name")
--------
    1

Example 2

An XA transaction “txn_name” is running on instance “ase2”. The connection can migrate.

select xact_connmigrate_check("txn_name")
--------
    1

Example 3

An XA transaction “txn_name” is running on instance “ase2”. The connection cannot migrate.

select xact_connmigrate_check("txn_name")
--------
    0

Usage

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

Any user can execute xact_connmigrate_check.

See also

Functions xact_owner_instance