+20528 A DATA CHANGE OPERATION FOR A TABLE WITH DBID.OBID dbid-value.obid-value, WHICH INCLUDES A PERIOD period-name, CAUSED AN ADJUSTMENT TO A RECORDED TIME VALUE FOR THE PERIOD.
Explanation
FL 507 The target of the data change operation is a table with that includes a period. The requested data change operation was performed and resulted in an adjustment to a recorded time value for the period.
- dbid-value.obid-value
- The DBID and OBID of the table that is the target of the data change operation.
- period-name
- The name of the period.
This adjustment can occur when two concurrent transactions are accessing the same row for data changes, if the SYSTIME_PERIOD_ADJUST global variable is set to Y. For an update operation, the adjustment affects both the start and end columns for the period. For a delete operation, the adjustment only affects the end column for the period.
System action
Processing continues. The statement was processed with an adjustment to the recorded time for the period.
User response
If you did not want the adjustment, issue a rollback and retry the transaction.
Otherwise, no action is required.
Applications can block the adjustment of affected values by setting the SYSTIME_PERIOD_ADJUST global variable to N.
SQLSTATE
01695
