Document Type | Troubleshooting
Category | Administration
Applicable Product Version | 6FS07, 7FS02
Error Code | 7200
Document Number | TADTS053
Issue
UNDO_RETENTION=86400 parameter was set, and upon system startup, the following error occurred, preventing normal startup.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
UNDO_RETENTION <= _TSN_TIME_MAP_SIZE * _TSN_TIME_MAP_INTERVAL is a newly added condition that must be satisfied.Therefore, when the
undo_retention value is changed to a value larger than _TSN_TIME_MAP_SIZE, the above condition is not met, causing a tberr -7200 error.Solutions
1. Adjust the parameter value according to the formula
UNDO_RETENTION <= _TSN_TIME_MAP_SIZE * _TSN_TIME_MAP_INTERVAL.2. Apply the patch to resolve the issue. (Applied patch: 321199)
By applying this patch, the default size of
By applying this patch, the default size of
_TSN_TIME_MAP_SIZE will be increased from 10,000 to 200,000. Also, undo_retention value changes will internally adjust the _TSN_TIME_MAP_INTERVAL value, allowing users to freely change the undo_retention value without considering other parameter values.Caution
Apply the patch through technical support provided by Tmax Tibero.
Note
UNDO_RETENTION: Specifies the minimum time period in seconds that undo information can be retained.
(default: 900, dynamic parameter)
_TSN_TIME_MAP_SIZE: Size of the table holding TSN-TIME MAP information.
(default: 10000, type: INT32 / static parameter)
_TSN_TIME_MAP_INTERVAL: Interval period for adding TSN-TIME MAP information.
(default: MAX(UNDO_RETENTION/_TSN_TIME_MAP_SIZE, 1), type: INT32 / dynamic parameter)