SET_MAINT_MODE_RECORD_NO_TEMPORALHISTORY stored procedure

The SYSPROC.SET_MAINT_MODE_RECORD_NO_TEMPORALHISTORY stored procedure indicates that 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, and transaction-start-ID columns on subsequent operations.

Db2 continues to generate new values for row-begin, row-end, and transaction-start-ID columns that are not explicitly specified as the target of an assignment clause for a data change statement.

This procedure is not intended for general use. It is intended to be used by products that enable Db2 replication.

Note: The SYSPROC.SET_MAINT_MODE_RECORD_NO_TEMPORALHISTORY stored procedure is deprecated at V12R1M503. The procedure will continue to work if you run with APPLCOMPAT set to V12R1M502 or lower, as long as V12R1M502 is supported. The functionality provided by the procedure has been subsumed by the new SYSIBMADM.REPLICATION_OVERRIDE built-in global variable.

Begin program-specific programming interface information.

Environment

SET_MAINT_MODE_RECORD_NO_TEMPORALHISTORY must run in a WLM-established stored procedure address space.

Authorization

To execute the CALL statement, the owner of the package or plan that contains the CALL statement must have one or more of the following privileges:

  • The EXECUTE privilege on the SET_MAINT_MODE_RECORD_NO_TEMPORALHISTORY stored procedure
  • Ownership of the stored procedure
  • SYSADM authority

Syntax

The following syntax diagram shows the SQL CALL statement for invoking this stored procedure:

Read syntax diagramSkip visual syntax diagramCALLSYSPROC.SET_MAINT_MODE_RECORD_NO_TEMPORALHISTORY()

Description

The procedure has no parameters.

The result of the procedure is that recording of temporal history for a system-period temporal table is disabled, and an application is allowed to specify values for row-begin, row-end, and transaction-start-ID columns.

End program-specific programming interface information.