Database sequence numbers

Sterling Order Management System Software uses sequence numbers to ensure that the generated primary key values are unique.

   create sequence <sequence-name> cycle cache 10000 no order; 

The cache option tells Db2® to preallocate a set of sequences in memory for performance. With a cache of 10000, the first request goes to disk to get the first sequence number. The next 9999 requests are satisfied in memory. Without the cache option, all requests go to disk.

The NO ORDER option, which is the default, allows each Db2 pureScale® member to cache its own set of sequence numbers for performance.