Table 8-41 shows the status of the database and recovery method in the event of an error during index reorganization.

Table 8-41 Status of database and recovery method in the event of error during index reorganization

-l option	Status/Recovery method		Message output immediately before error occurred
			None	725	715	716
a or p	Status		Status before execution	Status before execution	Index not created	Index creation completed
	Recovery		Re-execute reorganization	Re-execute reorganization	Execute batch creation*	Unnecessary
n	Status	Table	Status before execution	Status before execution	Status before execution	Status before execution
		Index	Status before execution	Status before execution	Not guaranteed	Creation completed
	Recovery	Table	Unnecessary	Unnecessary	Unnecessary	Unnecessary
		Index	Re-execute reorganization	Re-execute reorganization	Re-execute batch creation after recovering database*	Unnecessary

Legend:

725: Index unloading started

715: Batch index creation started

716: Batch index creation completed

Note

Messages are abbreviated. For example, 725 means KFPL00725-I.

^* If you recovered the index storage RDAREA by re-initializing the RDAREA instead of using its backup copy, re-execute the index re-creation.