DB2 Error Code – -613 the primary key or a unique constraint is too long or has too many columns

In this post, you’ll learn about the error message -613 the primary key or a unique constraint is too long or has too many columns in the IBM DB2 database , the reason why it occurs along with the solution to fix it

IBM DB2 Error Message

-613 the primary key or a unique constraint is too long or has too many columns

Reason for the Error

In a list of columns following either PRIMARY KEY or UNIQUE,the number of columns is greater than 64 or the sum of the column length attributes is greater than the number allowed for the type of index.

Solution

Change the table definition to keep within the prescribed limits.