Residency and the Changing Status of Fragments

If new fragments are added to a resident table, the fragments are not marked automatically as resident. You must issue the SET Residency statement for each new fragment or reissue the statement for the entire table.

Similarly, if a resident fragment is detached from a table, the residency state of the fragment remains unchanged. If you want the residency state to change to nonresident, you must issue the SET Residency statement to declare the specific fragment (or the entire table) as nonresident.