IBM PureData System for Analytics, Version 7.1

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.

Note: When you change a sequence and flush the cache, change the starting value to ensure more sequential NEXT VALUE results.