Skip to main content
๐Ÿ““ Tibero Online Manual Click here ๐Ÿ““

Search

Welcome to Tibero GTS!

Considerations When Changing the UNDO_RETENTION Parameter

Document Type | Troubleshooting 

Field | Administration/Configuration

Applicable Product Versions | 6FS07, 6FS07PS, 7FS02, 7FS02PS

Error Code | 7200

Document Number | TADTS003

 

Issue

UNDO_RETENTION=86400 parameter is set and the system is started, the following error occurs, preventing the system from starting normally.
 
iparam condition check failed. name:_TSN_TIME_MAP_INTERVAL, value: 8
*** Tibero initialization parameter (tip) file failure:
Error (-7200) occurred while processing parameter '_TSN_TIME_MAP_INTERVAL' and value '8'    (_TSN_TIME_MAP_INTERVAL must be between 0 and 2147483647)..
Tip file path = /tibero/tibero7/config/$TB_SID.tip

 

Cause

In Tibero7, when changing theUNDO_RETENTION value, the system can only start within the range satisfying the condition 
UNDO_RETENTION <= _TSN_TIME_MAP_SIZE * _TSN_TIME_MAP_INTERVAL. Setting UNDO_RETENTION to 86400 does not satisfy this condition, causing the error.

 

Solutions

1. Resolution by Adjusting Parameters

Change the value of either_TSN_TIME_MAP_INTERVAL or _TSN_TIME_MAP_SIZE to satisfy the parameter condition.
Note
_TSN_TIME_MAP_SIZE : Size of the table holding TSN-TIME MAP information 
                              (default: 10000, type: INT32 / static parameter)
 
_TSN_TIME_MAP_INTERVAL : Interval for adding TSN-TIME MAP information 
(default: MAX(UNDO_RETENTION/_TSN_TIME_MAP_SIZE, 1), type: INT32 / dynamic parameter)
  • _TSN_TIME_MAP_INTERVAL should be adjusted carefully because increasing it limits Flashback query usage to changes within the _TSN_TIME_MAP_INTERVAL period.
  • _TSN_TIME_MAP_SIZE is recommended to be set equal to the UNDO_RETENTION value, maintaining _TSN_TIME_MAP_INTERVAL at 1 second. Changing _TSN_TIME_MAP_SIZE requires a restart and increases the size of the table storing TSN-TIME MAP information.
 

2. Apply FS02_321199a Patch

tsn time map size is increased from 10,000 to 200,000 by default.
Also, when changing the UNDO_RETENTION value, the _TSN_TIME_MAP_INTERVAL value is internally adjusted, allowing users to change the UNDO_RETENTION value without having to consider other parameter values.
 
 
 

Related to