In this post, you’ll learn about the DB2 error 511-Attempt to update or insert row failed because resultant row of size 2009 bytes is larger than the maximum size (1961 bytes) allowed for this table. and the reason why you are receiving the error message and how to fix it
How does this Error Message Looks like
511 – Attempt to update or insert row failed because resultant row of size 2009 bytes is larger than the maximum size (1961 bytes) allowed for this table.
Reason for the Error & Solution
Possible attempt to store a string of a length greater than is allowed by the database’s column definition. If creation is done via the mapping tool, ensure that the length attribute of the column element specifies a large enough size for the column.