temporary memory of job increases massive when using CLOB/JSON field in SQL-request

[nedi-dev]

temporary memory of job increases massive when using CLOB/JSON field in SQL-request

[nedi-dev]

From IBM Service we received a PTF for IBM i 7.4 that solved this issue:
https://www.ibm.com/support/pages/ptf/SI79954
SI79954 - OSP-DB-OTHER SQL JSON BUILT-IN FUNCTIONS DO NOT RELEASE USED

[kadler]

Since this same issue occurs for you in both idb-connector and node-odbc, I suspect it has nothing to do with the database connector used (and you'd get the same result in pure ODBC or JDBC or whatever).

My guess is this is due to the job keeping the lob locator open or the cursors are only pseudo-closed, keeping resources around. You can try setting OPEN_CURSOR_CLOSE_COUNT or LOB_LOCATOR_THRESHOLD in QAQQINI to have these resources free up sooner: https://www.ibm.com/docs/en/i/7.3?topic=qaqqini-query-options

[github-actions]

👋 Hi! This issue has been marked stale due to inactivity. If no further activity occurs, it will automatically be closed.