CONSISTENTVIEWOPENTRANSACTIONS 

Definition

The system table CONSISTENTVIEWOPENTRANSACTIONS describes the transactions that were active when the consistent view was generated.

Structure

CONSISTENTVIEWOPENTRANSACTIONS

CONSISTENTVIEWID	FIXED(15)	ID of the consistent view
TRANSACTIONID	FIXED(15)	ID of the transaction that was active when the consistent view was generated

Concepts of the Database System, Example: Consistent View