PM11933: ABEND04E DSNXOLTI:M630 STORAGE OVERLAY WITH INDEX ON EXPRESSION SMCOVERLAY DB2OVRLAY/K

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND04E RC00E70005 DSNXOLTI:M630 (caused by Storage overlay)
  may occur during index on expression (IOE) exploitation if
  the following conditions are met:
  
  1. a base table has more than 256 key expressions in indexes
  2. a query that references the base table has more than 256
     expressions
  3. there are more than 256 expression matches between key
     expressions in indexes and expressions in the query
  
  (D139977)
  
  Additional keywords: SMCOVERLAY SQLINDEXONEXP
  DB2OVRLAY/K DB2INCORR/K
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 9 users who define more than 256     *
  *                 key expressions in the indexes and           *
  *                 reference more than 256 expressions in       *
  *                 the query and there are more than 256        *
  *                 key expressions in the indexes match to      *
  *                 expressions in the query                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: ABEND04E RC00E70005 DSNXOLTI:M630       *
  *                      may occur during index on expression    *
  *                      exploitation if the following           *
  *                      conditions are met:                     *
  *                                                              *
  *                      1. a base table has more than 256 key   *
  *                         expressions in indexes               *
  *                      2. a query that references the base     *
  *                         table has more than 256 expressions  *
  *                      3. there are more than 256 expression   *
  *                         matches between key expressions in   *
  *                         indexes and expressions in the query *
  *                                                              *
  *                      The problem investigation shows the     *
  *                      symptom is unpredictable because the    *
  *                      cause is a storage overlay.             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  ABEND04E RC00E70005 at DSNXOLTI:M630 or other symptoms such
  as ABEND0C4 at various modules or even incorrect output may
  occur if the following conditions are met:
  
  1. a base table has more than 256 key expressions in indexes
  2. a query that references the base table has more than 256
     expressions
  3. there are more than 256 expression matches between key
     expressions in indexes and expressions in the query
  
  During index on expression exploitation, a storage overlay
  occurs. Depending on which data structures are overlaid the
  problem symptoms vary from abends to incorrect output.
  

Problem conclusion

• DB2 has been modified to ensure the storage overlay problem
  described above no longer occurs.
  
  Additional keywords: ABEND04E ABEND0C4 INCORROUT
                       SMCOVERLAY SQLINDEXONEXP
                       SQLKEYEXP
  

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:

  UK56700

Modules/Macros

• DSNXODTR DSNXOFN2 DSNXOKEX DSNXOLNK DSNXOTIR
  DSNXOVP  DSNXOV1
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• R910 PSY UK56700

     UP10/05/19 P F005

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.