PI47373: ABEND04E RC00E70005 IN DSNXOGP M103 WHEN TRYING TO PREPARING A SQL STATEMENT WITH A COMPLEX VIEW

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND04E RC00E70005 IN DSNXOGP M103 WHEN TRYING TO PREPARING A
  SQL STATEMENT WITH A COMPLEX VIEW
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of DB2 10 and 11 for z/OS who      *
  *                 have queries referencing many tables and     *
  *                 IN-list predicates                           *
  ****************************************************************
  * PROBLEM DESCRIPTION: ABEND04E RC00E70005 in DSNXOGP M103 can *
  *                      occur for a query referencing a very    *
  *                      large number of tables and containing   *
  *                      IN-list predicates                      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  ABEND04E RC00E70005 in DSNXOGP M103 can occur for a query
  referencing a very large number of tables and containing
  IN-list predicates.  As the number of tables approaches the
  internal limit, the number of IN-list predicates that can
  be converted to IN-list direct table access decreases.  If
  too many IN-list predicates are converted to IN-list direct
  table access, this abend can occur.
  
  Additional Keywords:
  SQLIN INLIST
  

Problem conclusion

• DB2 code is updated to minimize the number of IN-list predicates
  that are converted to IN-list direct table access when the
  number of tables in the query approaches the limit.  If
  the statement is too complex, SQLCODE -101 will be issued
  from DSNXOSO3 instead of abending.
  

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:

  UI33404 UI33405

Modules/Macros

• DSNXOCS  DSNXOCSC DSNXOCSH DSNXOCSN DSNXOGP
  DSNXOPRP DSNXORAC DSNXOSO3
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UI33404

     UP15/12/15 P F512

• RB10 PSY UI33405

     UP15/12/15 P F512

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.