Skip to content

Error – Record size limit exceeded

ISSUE:
You may get below error message when running a SQL query with REPLACE function.
ERROR: 229008 : Record size limit exceeded

DESCRIPTION:
You will face this error when you are using SQL extension toolkit version 1.6.1. It is a know defect 78087 reported with IBM and still there is no fix.

To check SQL extension toolkit, run below command in system database.
SYSTEM(ADMIN)=> SELECT regexp_version();
REGEXP_VERSION
————————————————————
IISI XML / Regular Expression Library Version 1.6.1 Build ()
(1 row)

RESOLUTION:
THere is no permanent fix available at this time. As a work around you cna downgrade to lower version of SQL extension toolkit like SQLEXT 1.4 and try to run your sql. It should run without issues.