PM81762: ABEND04E RC00E72088 AT DSNXSINE OFFSET 318C WHEN INSERT STATEMENT THAT CONTAINS ORDER BY

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Abend04e rc00e72088 at dsnxsine offset 318c may happen when
  insert statement contains order by.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 9 and 10 for z/OS users of an INSERT *
  *                 with SELECT statement that contains ORDER BY *
  *                 and a LOB column in the SELECT list.         *
  ****************************************************************
  * PROBLEM DESCRIPTION: ABEND04E RC00E72088 at the location     *
  *                      DSNXGRDS DSNXSINE OFFSET3196 could      *
  *                      happen for an INSERT with SELECT        *
  *                      statement that contains ORDER BY and a  *
  *                      LOB column in the SELECT list.          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The problem can be observed in the following example:
  
  CREATE TABLE T1 (
    C1 VARCHAR(8),
    C2 CLOB(1 M)
  );
  
  CREATE TABLE T2 (
    C1 VARCHAR(8),
    C2 CLOB(1 M)
  );
  
  INSERT INTO T2
    SELECT * FROM T1
    ORDER BY C1;
  
  
  DB2 did not correctly process the aforementioned SQL statements,
  which caused the ABEND.
  

Problem conclusion

• DB2 has been modified to correctly process the aforementioned
  SQL statements, so there will be no ABEND.
  
  Additional keywords: SQLINSWSELECT SQLORDERBY SQLLOB
  

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:

  UK93203 UK93204

Modules/Macros

• DSNXOB2
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK93203

     UP13/04/23 P F304

• R910 PSY UK93204

     UP13/04/23 P F304

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.