This table defines the range of key values for all tables that require a unique key.

Column Descriptions:

KEYS_IDINTEGER NOT NULLThe internally generated unique ID.
TABLENAMEVARCHAR (18) NOT NULLThe table into which the next key value is inserted.
COLUMNNAMEVARCHAR (18) NOT NULLThe column into which the next key value is inserted.
COUNTERBIGINT NOT NULLThe next starting key value to be fetched by the server from the database.
PREFETCHSIZEBIGINT DEFAULT 20The size of the block of keys prefetched by the server.
LOWERBOUNDBIGINT DEFAULT 0The lower bound of the range of key values available for this table.
UPPERBOUNDBIGINT DEFAULT 2147483648The upper bound of the range of valid key values for this table.
NONSEQUENTIALCHAR (1) NOT NULL DEFAULT '0'Reserved for IBM internal use.
MULTIPLIERBIGINT NOT NULL DEFAULT 1048576Reserved for IBM internal use.
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.


NameColumn NamesType
I0000144TABLENAMEUnique Index