This table is used by the IdResolver to resolve the primary identifiers of the database tables. If a new table is added to the schema, and if the primary identifier has to be resolved, an entry for that table has to be made in the SUBKEYS table. It is used in the same way as the KEYS table is used.
Column Description(s):
Column Name | Column Type | Description |
SUBKEYS_ID |
INTEGER NOT NULL |
The internally generated unique ID. |
TABLENAME |
CHAR(10) NOT NULL |
The table into which the next key value is inserted. |
COLUMNNAME |
CHAR(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 |
I0000241 |
TABLENAME |
Unique Index |
SQL050212031316810 |
SUBKEYS_ID |
Primary Key |
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.