Any access plans that reference the table or view are implicitly prepared again when a program that uses the access plan is next run. Since the program refers to a table or view with the original name, if a table or view with the original name does not exist at that time, an error is returned.
Any access plans that reference the index are not affected by rename.
If the name of the object and the system name of the object are the same and new-table-identifier is not specified, specifying system-object-identifier will be the new name and system object name. Otherwise, specifying system-object-identifier will only affect the system name of the object and not affect the name of the object.
If both new-table-identifier and system-object-identifier are specified, they cannot both be valid system object names.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.