PI82852: ABEND04E AT DSNXUTL:M100 WHEN A QUERY WAS EXECUTED USING THE JSON_VAL FUNCTION

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND04E at DSNXUTL:M100 when a query was executed using the
  JSON_VAL function. In the problem query, JSON_VAL's result type
  is set to 's:', but length is ommitted
  

Local fix

• specify the missing length in JSON_VAL function
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 V10 or V11 for z/OS users of an SQL  *
  *                 statement containing a JSON_VAL function     *
  *                 whose result type is VARCHAR, or VARCHAR     *
  *                 FOR BIT DATA, but the length is omitted.     *
  ****************************************************************
  * PROBLEM DESCRIPTION: Abend04E RC00E70005 at DSNXUTL M100     *
  *                      can occur for an SQL statement          *
  *                      satisfying all of the following         *
  *                      conditions:                             *
  *                      1. It contains a JSON_VAL function      *
  *                      whose result type is VARCHAR, or        *
  *                      VARCHAR FOR BIT DATA.                   *
  *                      2. The length is omitted.               *
  *                                                              *
  *                      After application of this PTF, SQLCODE  *
  *                      -171 will be issued instead of          *
  *                      ABEND04E.                               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  An example is shown below:
  
  CREATE TABLE TJ(CUSTOMERDATA BLOB(1000),
                  C2 VARCHAR(8), C3 VARCHAR(8));
  
  SELECT JSON_VAL(CUSTOMERDATA,'Customer.name', 'b:') as "Name",
         JSON_VAL(CUSTOMERDATA,'Customer.phone', 's:') as "Phone"
  FROM  TJ;
  
  DB2 did not correctly process the aforementioned SQL statement
  and resulted in ABEND04E RC000E70005 at DSNXUTL M100.
  
  After application of this PTF, SQLCODE -171 will be issued
  instead of ABEND04E.
  

Problem conclusion

• DB2 has been modified to correctly process the SQL statement.
  
  Additional Keywords: JSON
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

  PI82022

• APAR is sysrouted TO one or more of the following:

  UI49083 010PC2Ÿ 010PC2Ÿ UI49084 010PC2Ÿ 010PC2Ÿ 010PC2Ÿ

Modules/Macros

• DSNXOBFA
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UI49083

     UP17/08/10 P F708

• RB10 PSY UI49084

     UP17/08/10 P F708

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.