TEMPORAL_LOGICAL_TRANSACTIONS built-in global variable

The TEMPORAL_LOGICAL_TRANSACTIONS global variable contains a value that specifies whether multiple temporal logical transactions are allowed within a single unit of work.

The TEMPORAL_LOGICAL_TRANSACTIONS global variable has the following characteristics:
  • It is updatable, with values maintained by the user or the system.
  • The type is SMALLINT.
  • It is NOT NULL.
  • The schema is SYSIBM.
  • The scope of this global variable is session.
The global variable can be set to the following:
0
Disallows multiple temporal logical transactions in a single unit of work. This is the default value.
1
Allows multiple temporal logical transactions in a single unit of work.