PI04986: AUXILIARY STORAGE SHORTAGE HANG MAY OCCUR FOR A VERY LARGE QUERY INVOLVING A VERY LARGE NUMBER OF TABLES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Auxiliary storage shortage may occur for a very large query
  referencing a very large number of tables, possibly resulting
  in a hang.                                          (d169251)
  DB2MIGV11/K
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of DB2 11 for z/OS who             *
  *                 have large queries with many tables          *
  *                 in the query.                                *
  ****************************************************************
  * PROBLEM DESCRIPTION: Auxiliary storage shortage              *
  *                      may occur when DB2 is processing        *
  *                      a very large query involving many       *
  *                      tables. It can cause the BIND           *
  *                      PACKAGE / PREPARE process to hang.      *
  *                                                              *
  *                      DB2HANG SQLSTORAGE                      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  An auxiliary storage shortage hang may occur when DB2 is
  processing a very large query involving many tables.
  
  The problem occurs because DB2 is allocating too much
  storage that ends up not being used during the access
  path generation.
  

Problem conclusion

• The auxiliary storage shortage problem described above
  is fixed by freeing unused storage when DB2 generates
  the access path.
  

Temporary fix

• *********
  * HIPER *
  *********
  

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI15964

Modules/Macros

• DSNXOSJO DSNXOTS
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RB10 PSY UI17091

     UP14/05/07 P F405 ½

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.