IBM Support

Record size exceeds internal limit of 65535 bytes

Question & Answer


Question

Why am I getting the Error: Record size exceeds internal limit of 65535 bytes message?

Answer

When running a query, you may get an error similar to the following:

Error: Record size 90220 exceeds internal limit of 65535 bytes


The error indicates that the row size has exceeded the permissible limit of 65K (65535 bytes).

To help troubleshoot this error, check to see if there are large CHAR(), VARCHAR(), NVARCHAR(), etc. columns that you can make smaller.

For more information, refer to the IBM Netezza Database User’s Guide.

[{"Product":{"code":"SSULQD","label":"IBM PureData System"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":null,"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"1.0.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Historical Number

NZ689333

Document Information

Modified date:
17 October 2019

UID

swg21569907