The number of unique sequences supported in a database varies by block size. An application that uses more than 250 sequences does not work on all database block sizes. The table below lists the number of sequences per database block size.
Table 7. Maximum number of sequences
Database block size
Maximum number of sequences
1024 bytes (1K)
250
2048 bytes (2K)
500
4096 bytes (4K)
1000
8192 bytes (8K)
2000
Newly created databases have 64-bit sequences.
Databases migrated from a previous release, that do not have 64-bit sequences can enable support for 64-bit sequences with the PROUTIL ENABLESEQ64 command. See the PROUTIL ENABLESEQ64 qualifier on page 1211 for details.
Existing sequences with the upper limit specified as the Unknown value (?) were bounded by the maximum of a signed 32-bit integer in prior releases. When 64-bit sequences are enabled, they are bounded by the maximum of a signed 64-bit integer.
For more information on 64-bit sequences, see the online Help for the Data Dictionary or Data Admin.
