Error – Record size limit exceeded
You may get below error message when running a SQL query with REPLACE function.
ERROR: 229008 : Record size limit exceeded
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();
IISI XML / Regular Expression Library Version 1.6.1 Build ()
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.