Increase the concurrency of sequences

Increase the concurrency of sequences If you use a sequence generator (created with the CREATE SEQUENCE statement), you can increase its concurrency by doing the following. sequencesconcurrency concurrencysequences

Do not query the SYSSEQUENCES system table directly. Instead, use the SYSCS_UTIL.SYSCS_PEEK_AT_SEQUENCE system function to obtain the current value of a sequence generator.
Specifying a higher value for the derby.language.sequence.preallocator property may increase your concurrency. However, you should pay special attention to bringing down the database in an orderly fashion so as not to leak unused preallocated values. (See also .)

See the for more information about the CREATE SEQUENCE statement, the SYSSEQUENCES system table, the SYSCS_UTIL.SYSCS_PEEK_AT_SEQUENCE system function, and the derby.language.sequence.preallocator property.