A fix is available
APAR status
Closed as program error.
Error description
ABEND04E RC00E70005 AT DSNXGRDS.DSNXVUTF:M101 may occur when many JSON_VAL functions are referenced in predicate of SQL statement KEYWORDS: ABEND04E RC00E70005 SQLFUNCTION
Local fix
BYPASS/CIRCUMVENTION: N/A
Problem summary
**************************************************************** * USERS AFFECTED: * * All Db2 12 for z/OS users who invoke * * SYSIBM.JSON_VAL built-in function. * **************************************************************** * PROBLEM DESCRIPTION: * * ABEND04E RC00E70005 at DSNXVUTF M101 * * may occur from SQL statement where * * multiple SYSIBM.JSON_VAL functions * * are being invoked. * **************************************************************** * RECOMMENDATION: * * Apply corrective PTF when available * **************************************************************** The following example could recreate the problem: SELECT JSON_VAL(BSON_COL, 'field101', 'i'), .... JSON_VAL(BSON_COL, 'field150', 'i') FROM JSON_TABLE WHERE JSON_VAL(BSON_COL, 'field1', 'i') > 1 OR .... JSON_VAL(BSON_COL, 'field100', 'i') > 1; Db2 didn't handle multiple SYSIBM.JSON_VAL invocations correctly and caused ABEND04E RC00E70005 at DSNXVUTF M101.
Problem conclusion
Db2 is updated so the aforementioned SQL with multiple SYSIBM.JSON_VAL invocations is fixed. Additional Keywords: JSON
Temporary fix
Comments
APAR Information
APAR number
PH41209
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
C10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2021-10-11
Closed date
2021-11-22
Last modified date
2021-12-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI78219
Modules/Macros
DSNXOW2D
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RC10 PSY UI78219
UP21/11/30 P F111
Fix is available
Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"DB2 for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"12.0"}]
Document Information
Modified date:
02 December 2021