SIB - recovery of indexes

Document ID : KB000100133
Last Modified Date : 12/06/2018
Show Technical Document Details
Question:
Does CA Secondary Index Builder rebuild all the indexes without having an CA UNLOAD file? 
Answer:
CA Secondary Index Builder can run standalone after reorganization to build secondary indexes separately (FUNCTION=INDEXBUILD). Also Secondary Index Builder can run after recovering a main database to recreate primary and secondary indexes separately (FUNCTION=INDEXCREATE). You will restore the database from Image Copy as usual and then use FUNCTION=INDEXCREATE to build the secondary index. You do not need UNLOAD file, indexes can be created from the main Database using, of course we recommend to back up everything before attempting any recover.