Glb.TwoPC is a read-writable built-in segment attribute that is used with external automatic entries. It specifies the default transaction commit level of an external automatic entry. Its default value is specified by the segment's Two-Phase Commit property.

Glb.TwoPC must be set before the first external automatic entry in a transaction.

For OLTP external automatic entries, the Glb.TwoPC value remains in effect only for the current transaction.

For Hub external automatic entries, if the Glb.TwoPC value is changed from Y to N, it is ignored, and the Glb.TwoPC value is be treated as Y for all subsequent external automatic entries in that transaction. If it is changed from N to Y after the first external automatic entry, it is recognized. This allows execution of an initial non-two-phase commit automatic entry inquiry before executing a two-phase commit global transaction for the updates.

In reports, the transaction commit level can be changed after each CriticalPoint or Sleep logic statement.

In a chain of external automatic entries, the commit level is that imposed by the ultimate originator.

Properties

Length = 1

Primitive = String