Table 8-40 shows the status of the database and recovery method in the event of an error during re-creation or batch creation of an index.

Table 8-40 Status of database and recovery method in the event of error during re-creation or batch creation of an index

-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 re-creation	Re-execute re-creation	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 re-creation	Re-execute re-creation	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 the index to be recovered is a plug-in index, the utility can be executed only if the batch plug-in index creation partial recovery facility is provided. Otherwise, the index re-creation process is re-executed.