|Following the section titled "Using the Index Advisor", add the following |section:
|It is possible to allow columns with a length greater than 255 bytes to |be specified as part of an index key. The DB2_INDEX_2BYTEVARLEN registry variable |allows for the use of 2 bytes instead of 1 to store the length of an index |key.
|There are several SQL statements affected by changes to the registry variable. |They are: |
|The foreign key restriction to 255 bytes is removed no matter |what the value of the registry variable. The truth-condition for the primary |key corresponding to the foreign key enforces any restriction or limit. |
|To convert existing indexes to use larger index keys: drop the indexes, |set the DB2_INDEX_2BYTEVARLEN registry variable to ON, and then recreate the |indexes (using the larger columns).
|For more information on the SQL statements, including syntax descriptions, |refer to the SQL Reference.