Flush the cache when you alter a sequence

When you alter a sequence, the system attempts to preserve existing cache loads on the host and the SPUs. The system, however, flushes the cache under the following circumstances:

• The ALTER SEQUENCE statement includes RESTART WITH.
• The ALTER SEQUENCE statement changes the INCREMENT BY value of a sequence.
• The ALTER SEQUENCE statement raises the MINVALUE of an ascending sequence.
• The ALTER SEQUENCE statement lowers the MAXVALUE of a descending sequence.