Error tolerance control

The ERROR_THRESHOLD keyword can be used to enable the reorganization function to encounter and bypass a specified number of UOWs containing pointer errors without terminating. When ERROR_THRESHOLD is used with the REORGANIZE command, any UOW where a pointer error is detected is not reorganized (remains unchanged). Processing continues with the next eligible UOW. When the number of UOWs where errors are encountered exceeds the value specified on the ERROR_THRESHOLD keyword, processing of the area terminates.

When the default value of 0 (zero) is in effect for the ERROR_THRESHOLD keyword, reorganization of the area terminates when the first pointer error is encountered.

The example in the following figure requests a reorganization and will bypass up to three UOWs containing pointer errors. The UOWs that contain pointer errors are not reorganized. If a fourth UOW that contains a pointer error is encountered, the reorganization is terminated.

REORGANIZE DBD=dbdname,SELECT_UOW=ALL,ERROR_THRESHOLD=3