6. Database Tailoring and Retrofitting Techniques › 6.3 Retrofitting Guidelines › 6.3.2 Retrofitting Database Files

6.3.2 Retrofitting Database Files

Changing the control data elements of a file amounts to
changing the file's key structure.  Adding or deleting a key
data element usually affects the sort sequence of the file.
Even changing the contents of existing key data elements can
affect the sort sequence.

The general recovery job template shown in the previous
section works for cases in which the key structure of the
file is not changed (there is no sort and summarization of
the treated data).  If the key structure of the file is
affected, there are several possibilities for file action:

    - Value change only
    - Value change, order change
    - Value change, order change, and granularity change