REPLICATION_OVERRIDE

Indicates whether Db2 is to disable recording of temporal history for a system-period temporal table and allow an application to specify values for row-begin, row-end,transaction-start-ID, and generated expression columns.

Begin program-specific programming interface information.

The global variable does not affect new values for row-begin, row-end, transaction-start-ID, and generated expression columns that are not explicitly specified as the target of an assignment clause for a data change statement. Db2 continues to generate values for these columns in other contexts.

This global variable has the following characteristics:
  • It is updatable, with values maintained by the user.
  • The type is CHAR(1).
  • The schema is SYSIBMADM.
  • The scope of this global variable is session.
  • The default value is 'N'
The global variable can be set to the following:
N
An application is not allowed to specify values for row-begin, row-end, transaction-start-ID, and generated expression columns. The recording of temporal history for a system-period temporal table is enabled.

N is the default.

Y
An application is allowed to specify values for row-begin, row-end, transaction-start-ID, and generated expression columns. The recording of temporal history for a system-period temporal table is disabled.

The REPLICATION_OVERRIDE built-in global variable is not intended for general use. It is intended for use by products that enable Db2 replication. The READ privilege on the variable is granted to PUBLIC. The WRITE privilege on the variable is not granted to PUBLIC.

Setting the SYSIBMADM.REPLICATION_OVERRIDE built-in global variable to 'Y' overrides the following default behaviors:
  • Row-begin, row-end, transaction-start-ID, and generated expression columns are normally defined so that Db2 always generates the values. When the override is in effect, insert or update operations can specify values for row-begin, row-end, transaction-start-ID, or generated expression columns.
  • Update and delete operations for system-period temporal tables normally generate historical rows. When the override is in effect, historical rows are not written to the associated history table for update and delete operations.

End program-specific programming interface information.