KEYS

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

Column Descriptions:

Name	Type	Description
KEYS_ID	INTEGER NOT NULL	The internally generated unique ID.
TABLENAME	VARCHAR (30) NOT NULL	The table into which the next key value is inserted.
COLUMNNAME	VARCHAR (30) NOT NULL	The column into which the next key value is inserted.
COUNTER	BIGINT NOT NULL	The next starting key value to be fetched by the server from the database.
PREFETCHSIZE	BIGINT DEFAULT 20	The size of the block of keys fetched by the server.
LOWERBOUND	BIGINT DEFAULT 0	The lower bound of the range of key values available for this table.
UPPERBOUND	BIGINT DEFAULT 2147483648	The upper bound of the range of valid key values for this table.
NONSEQUENTIAL	CHAR (1) NOT NULL DEFAULT '0'	Reserved for IBM internal use.
MULTIPLIER	BIGINT NOT NULL DEFAULT 1048576	Reserved for IBM internal use.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	KEYS_ID	Primary Key
I0000144	TABLENAME	Unique Index

Related reference
System data model