DB2 Error Code – -136 sort cannot be executed because the sort key length is greater than 4000 bytes

In this post, you’ll learn about the error message -136 sort cannot be executed because the sort key length is greater than 4000 bytes in the IBM DB2 database , the reason why it occurs along with the solution to fix it

IBM DB2 Error Message

-136 sort cannot be executed because the sort key length is greater than 4000 bytes

Reason for the Error

A sort key is derived from the list of columns specified following a DISTINCT qualifier, or in an ORDER BY or GROUP BY clause.� If both a DISTINCT qualifier and an ORDER BY or GROUP BY clause are present, the sort key is derived from the combination of both lists of columns.� The internal length of the sort key cannot exceed 4000 bytes.� In attempting to process the SQL statement, the internal length of the sort key derived from the DISTINCT and/or ORDER BY or GROUP BY specifications was found to exceed that 4000-byte maximum.

Solution

The statement must be modified such that the internal length of the sort key will not exceed 4000 bytes.� In general, this means that one or more column names must be deleted from the ORDER BY or GROUP BY clause, or the list following the DISTINCT qualifier.

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