SYS.SEQUENCES

The SEQUENCES table contains all the information about sequences.

Columns

Column name	Type	Description
NAME	TT_CHAR(31) NOT NULL	Sequence name
OWNER	TT_CHAR(31) NOT NULL	Sequence owner
MINVAL	TT_BIGINT NOT NULL	Minimum value
MAXVAL	TT_BIGINT NOT NULL	Maximum value
INCREMENT	TT_BIGINT NOT NULL	Increment value
CACHESIZE	TT_BIGINT NOT NULL	Number of sequence number to be cached For internal TimesTen use.
LASTNUMBER	TT_BIGINT NOT NULL	Last number incremented
UNIQID	TT_BIGINT NOT NULL	Reserved for internal use
SEQID	TT_BIGINT NOT NULL	ID of the sequence row
CYCLE	BINARY(1) NOT NULL	Flag to indicate to wrap around value
IS_REPLICATED	BINARY(1) NOT NULL	Sequence replication status 0 – Sequences are not being replicated. 1 – Sequences are being replicated.
REPACCESS	TT_CHAR(1) NOT NULL	Flag to indicate that sequences cannot be incremented on subscriber-only databases
BATCHSIZE	TT_BIGINT NOT NULL	Used in TimesTen Scaleout. Indicates number of sequence numbers that are batched. An element requests a large batch and caches according to the value of CACHESIZE. For internal use.
LASTBATCHNUMBER	TT_BGINT NOT NULL	Used in TimesTen Scaleout. Indicates the last batch number allocated. Used in all elements when NEXTVAL is needed and the cache is exhausted. The next cache size is taken from the existing batch, if available. Otherwise, the next batch is allocated and the next cache size is taken from the newly allocated batch. For internal use.
GLOBALLASTBATCHNUMBER	TT_BIGINT NOT NULL	Used in TimesTen Scaleout. Indicates the last global batch number allocated. The next batch is calculated in the element of the sequence owner and can be used locally or remotely. For internal use.