sysproxytxns table

The sysproxytxns table contains information about all of the current transactions that are running through each proxy distributor.

On the primary server, this table contains information about each of the proxy distributors in the high-availability cluster. On a secondary server, this table only contains information about the proxy distributors used to process updates to the secondary server.

The following table provides information about the columns in the sysproxytxns table:
Column Type Description
proxy_id integer ID of the proxy distributor. These IDs are unique within a high-availability cluster.
proxy_txn_id integer Number of the transaction. These numbers are unique to the proxy distributor.
reference_count integer Indicates the number of threads (for example, sqlexec, sync reply, recovery, and so on) that are using the information for this transaction. When the count becomes 0 this indicates the transaction processing is complete. (either successfully or unsuccessfully).
pending_ops integer On the primary server: the number of operations received from the secondary server that have not yet been processed. On the secondary server, the number of operations buffered on the secondary server that have not yet been sent to the primary server.
proxy_sid integer Proxy Session ID

Copyright© 2019 HCL Technologies Limited