Recovering from failure

The keyword RECOVER of the DSTUTIL command, analyses all of the records in the database, and extracts the keys for each. This information is written to a file identified by ddname EQQPKREC (this name cannot be changed). The file obtained in this way can be used to recover the primary index and ensure consistency with the data. Also, the secondary index recovery file can be obtained from the EQQPKREC file, which represents the input to recovery processes. This utility is useful if either the indexes or the data have been corrupted. For more information, see Defining initialization statements, under DSTUTIL.