scottklement.com

Thanks Scott

We managed to get some help from IBM , who have provided a PTF to resole this issue.

But we will look to implement YAJL procedures in future releases for JSON handling instead of using the SQL functions

Thanks Scott

I am trying to get in touch with the IBM meanwhile.

Also Would you have any better ideas for doing a PATCH to JSON elements , without using the SQL.

I have been looking at the YAJL procedures , and seems like they only provide exports to do a GET from JSON. Not sure if we are able to ...

Summary of the Issue :

A Batch job running under the HTTP server on IBM - I , meant for processing database updates to CLOBs using JSON_UPDATE SQL function shows excessive amount of temporary storage being consumed ( close to 8 GB )

Explanation of the process:
We have designed a new database ...