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.

Share:

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

In this post, you’ll learn about the error message -952 processing was interrupted by a cancel request from a client...
  • DB2
  • November 21, 2022
In this post, you’ll learn about the error message -927 the langrage interface was called when the connecting environment was...
  • DB2
  • November 21, 2022
In this post, you’ll learn about the error message -926 rollback not valid in ims/vs or cics environment in the...
  • DB2
  • November 21, 2022