Given the following ALTER SEQUENCE statement:
ALTER SEQUENCE myseq RESTART WITH 0 INCREMENT BY 1 NO MAXVALUE CACHE 5
ORDER
Assuming that the sequence had reached a value of 100 prior to the RESTART, which of the
following is true?
A.
The next value will be 0 and the sequence will never use the values 101 to 105.
B.
The next value will be 101 to ensure uniqueness between existing and newly generated
sequence values.
C.
Previously cached values are retained by DB2, and after the restart, will be used for values 101
to 105.
D.
The next value will be 0 and DB2 will not ensure uniqueness between existing and newly
generated values.
The ALTER SEQUENCE statement can be used to change a sequence in any of these ways:
Restarting the sequence
RESTART
Restarts the sequence. If numeric-constant is not specified, the sequence is restarted at the value specified implicitly or explicitly as the starting value on the CREATE SEQUENCE statement that originally created the sequence.
0
0