Synonym recovery

Select option Y from the DB2 Object Restore menu. You are prompted with the Enter Synonym Like window to identify the synonym with which you want to work.

Figure 1. Synonyms Like window

                                           
 Name Like            *                     
 Creator Like         *                     
 Display Dropped Only.N ( Y or N )

This message prompts you to enter a synonym and a creator, if known. Otherwise, you can enter a few letters and the wildcard character (*) to conduct a search for them or press Enter to view all synonyms and creators within the subsystem. The default is all (*). You can also indicate whether you want to display only dropped objects. If you specify N you will see all objects that match your selection criteria. If you specify Y you will see only objects that have been dropped.