This table defines the range of key values for all tables that require a unique key.
Column Description(s):
Column Name | Column Type | Description |
KEYS_ID |
INTEGER NOT NULL |
The internally generated unique ID. |
TABLENAME |
VARCHAR(18) NOT NULL |
The table into which the next key value is inserted. |
COLUMNNAME |
VARCHAR(18) 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 prefetched 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. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
I0000144 |
TABLENAME |
Unique Index |
SQL050212031236030 |
KEYS_ID |
Primary Key |
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.