Start of change

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.

Start of changeThis procedure is not intended for general use. It is intended to be used by products that enable DB2 replication.End of change

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:

>>-CALL--SYSPROC.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.

End of change