
Modifying existing profiles
You must take certain actions to apply changes to profiles.
Procedure
To modify existing profiles and apply the changes:
- Insert, update, or delete from the profile tables to define the changes.
- Issue a STOP PROFILE command.
- For changes to profiles for optimization parameters, production system modeling, or query acceleration thresholds, invalidate the statements in the statement cache to apply the access path changes. For information about completing this action, see Invalidating statements in the dynamic statement cache.
- Issue a START PROFILE command.
