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