IBM Support

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

A fix is available

Subscribe

You can track all active APARs for this component.

 

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 number

    PK90935

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    810

  • Status

    CLOSED PER

  • PE

    YesPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-07-09

  • Closed date

    2009-08-25

  • Last modified date

    2011-02-17

  • 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.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
17 February 2011