In this post, you’ll learn about the error message -614 the index cannot be created because the sum of the internal lengths of the identified columns is greater than the allowable maximum in the IBM DB2 database , the reason why it occurs along with the solution to fix it
IBM DB2 Error Message
-614 the index cannot be created because the sum of the internal lengths of the identified columns is greater than the allowable maximum
Reason for the Error
The index could not be created because the sum of the internal lengths of the key columns would exceed the allowable maximum. The maximum length permitted is a function of whether the index is partitioned or not, whether the index is unique or not, and the number of subpages of the index. For a nonpartitioned index with less than 8 subpages (either unique or not), the maximum permitted key length is 254.
Solution
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.