PK90935: ABEND04E RC00E20016 IN DSNSLD1 .DSNSVSTK+05B8 09/07/27 PTF PECHANGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND04E RC00E20016 in DSNSLD1 .DSNSVSTK+05B8 may occur for a
  query where a partitioning index exists or table-based
  paritioning exists on a table in the query
  

Local fix

• N/A
  Additional Symptoms:
  DSNKFTCH 5002 erqual5002
  read intent count in PCB is x'8000' 8000 pd 10/02/05
  
  DB2STGLK/K
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of DB2 for z/OS who collect        *
  *                 SYSIBM.SYSCOLSTATS statistics for their      *
  *                 partitioned tablespaces.  Those who have     *
  *                 PK62804 (UK38708 on V8; UK38709 on V9)       *
  *                 applied are more susceptible to the          *
  *                 problem.                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: ABEND04E RC00E20016 in                  *
  *                      DSNSLD1.DSNSVSTK+05B8 or similar        *
  *                      storage-related abends may occur on     *
  *                      bind or prepare of queries on a         *
  *                      partitioned tablespace where            *
  *                      SYSCOLSTATS have been gathered.         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  ABEND04E RC00E20016 in DSNSLD1 .DSNSVSTK+05B8 or various
  storage-related abends may occur when binding or preparing a
  query on a partitioned tablespace which has SYSCOLSTATS
  collected on it, if the query is part of a long-running
  transaction.  Storage creep can occur for these types
  of queries in long-running transactions, but the abend does
  not occur until an out-of-storage condition is encountered.
  The storage creep can only occur when parallelism is
  used for such queries, before PK62804 is applied.
  After PK62804 is applied, the storage creep could also
  occur for non-parallelism cases.
  
  Additional Keywords:
  SQLSTORAGE SQLCPUP
  

Problem conclusion

• Code is changed to free the storage properly in both the
  parallelism and non-parallelism cases for queries on
  partitioned tablespaces where SYSCOLSTATS are collected.
  

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:

  UK49580 UK49581

Modules/Macros

• DSNDOPCA DSNXOCN  DSNXODF  DSNXODF2 DSNXOLCM
  DSNXOLFN DSNXOPRS
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• R810 PSY UK49580

     UP09/09/10 P F909 ®

• R910 PSY UK49581

     UP09/09/10 P F909 ®

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.