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.
