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

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

If an XID is specified, xact_connmigrate_check returns:

• 1 if the connection is to the instance running the specified transaction, or the connection is to another instance in a migratable state

• 0 if the connection or transaction ID does not exist, or the connection is to another instance that is not in a migratable state

If an XID is not specified, xact_connmigrate_check returns:

• 1 if the connection is in a migratable state

• 0 if the connection does not exist or is not in a migratable state

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

Any user can execute xact_connmigrate_check.

See also