PH15848: ABEND0C4 RC00000038 IN DSNXOMW OFFSET04DE WHEN RUNNING A MERGE SQL STATEMENT THAT REFERENCES A DGTT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND0C4 RC00000038 in DSNXOMW OFFSET04DE when running a MERGE
  SQL statement that references a DECLARED GLOBAL TEMPORARY TABLE
  Additional Keywords:
  SQLMERGE SQLDGTT
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 12 for z/OS users with MERGE SQL                     *
  * statement that has an uncorrelated subquery                  *
  * predicate.                                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * ABEND0C4 RC00000038 at DSNXOMW +04DE                         *
  * may occur for a  MERGE SQL statement                         *
  * that has an uncorrelated subquery                            *
  * predicate and the subquery predicate                         *
  * is virtual table access.                                     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  ABEND0C4 RC00000038 at DSNXOMW +04DE may occur for a  MERGE
  SQL statement that has an uncorrelated subquery predicate and
  the subquery predicate is virtual table access.
  
  An example for the error case may be:
  
  MERGE INTO T1
  USING (SELECT C1, C2 FROM T2
  WHERE T2.C3 IN (SELECT DISTINCT C3
  FROM T3) )AS S(C1, C2)
  ON T1.C2 = S.C2
  WHEN NOT MATCHED
  THEN
  INSERT (C1,C2,C3) VALUES('3',5,'8')
  WHEN MATCHED
  THEN
  UPDATE SET (T1.C1,T1.C2) = (S.C1,S.C2) ;
  

Problem conclusion

• The bindtime code in DB2 is modified to correct the conditions
  leading to the ABEND.
  
  Additional Keywords: ABEND0C4 RC00000038  SQLMERGE SQLIN
                       SQLSUBQUERY
  

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:

  UI65516

Modules/Macros

• DSNXOMW
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI65516

     UP19/10/11 P F910

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.