DB2 Error Code – -614 the index cannot be created because the sum of the internal lengths of the identified columns is greater than the allowable maximum

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.