PH41209: ABEND04E RC00E70005 AT DSNXVUTF ERQUALM101 WHEN USING JSON_VAL FUNCTION

Obtain the fix for this APAR.

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 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.