DB2 SQL-Error: -614
SQLState: 54008
Short Description: THE INDEX CANNOT BE CREATED OR ALTERED OR THE LENGTH OF A COLUMN CANNOT BE CHANGED BECAUSE THE SUM OF THE INTERNAL LENGTHS OF THE COLUMNS FOR THE INDEX IS GREATER THAN THE ALLOWABLE MAXIMUM
The index could not be created or the length of a column cannot be changed because the sum of the internal lengths of the key columns would exceed the allowable maximum. The maximum permitted key length is as follows: v For PADDED indexes, the sum of the length attributes of the columns must not be greater than 2000-n, where n is the number of columns that contain null values. v For NOT PADDED indexes, the sum of the length attributes of the columns must not be greater than 2000-n-2m, where n is the number of nullable columns and m is the number of varying length columns.System action: The statement cannot be executed. The specified index was not created or the length of the column was not changed. Programmer response: The definition for the index must be modified (possibly by eliminating one or more key columns) to reduce the length of the key to the permitted maximum. Refer to Chapter 5 of DB2 SQL Reference if you require a complete explanation of other possible maximum key lengths and how they are computed.