PH19736: ABEND04E RC00E2000F at DSNXOAF DSNSVSFB OFFSET00A2A may happen for query of SELECT FROM data-change-table-reference

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND04E RC00E2000F at DSNXOAF DSNSVSFB OFFSET00A2A may happen
  for query of SELECT FROM data-change-table-reference, and the
  referrenced table has a large number of columns.
  
  Additional keywords:
  DB2OVRLAY/K
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 11 and 12 for z/OS users of an SQL                   *
  * statement containing a                                       *
  * data-change-table-reference on a base table                  *
  * with a large number of columns.                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * ABEND04E RC00E2000F at the location                          *
  * DSNXOAF DSNSVSFB OFFSET00A2A could                           *
  * happen for an SQL statement containing                       *
  * a data-change-table-reference on a                           *
  * base table with a large number of                            *
  * columns.                                                     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  An example is shown below:
  CREATE TABLE T1(
    C1 INT
   ,C2 INT
   ,C3 INT
   ,C4 INT
   ,C5 INT
     ...
   ,C300 INT
  )
  ;
  
  SELECT C1,C2,C3, ... C290
  FROM FINAL TABLE (
    UPDATE T1
    SET C1 = 0
    WHERE C2 = 2
  );
  Db2 did not correctly process the SQL statement, and it
  resulted in the ABEND.
  

Problem conclusion

• Db2 has been modified and the aforementioned SQL statement
  will run successfully.
  Additional keywords: SQLINSWSELECT SQLINSWSELECT SQLSELWUPDATE
                       SQLSELWDELETE SQLSELWMERGE SQLINSERT
                       SQLUPDATE SQLDELETE
  

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:

  UI67534 UI67535

Modules/Macros

• DSNXOIW1
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI67535

     UP20/02/06 P F002

• RB10 PSY UI67534

     UP20/02/06 P F002

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.