PM40789: ABEND04E RC00E20003 FROM DSNSVBK OR RC00E20016 FROM DSNSVSTK USING PAIR-WISE JOIN FOR THE QUERY WITH SET FUNCTION

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • ABEND04E RC00E20003 or RC00E20016 from DSNSVBK or DSNSVSTK
    for setfunction query using pair-wise join method and the
    pair-wise result rid is in a work file.
    For the parent thread, it should suspend in the DSNXRPJP and
    it accumulates many EMP blocks, RGD, DVS blocks.
    .
    There will be many children for this parents with PT status
    and many would be suspended in DSNTTSPD.
    .
    ACOMPIPE -> PIPENUMPPEL should also increase when this condition
    occur.
    .
    In V10, PM40770 addresses the part of the same code issue.
    The part of the V10 code that caused the INCORROUT does not
    exist in V9 and thus no INCORROUT in V9.
    .
    FIXCAT:  DB2STGLK/K   DB2PARALL/K
    .
    

Local fix

  • Disable Pair-wise Join
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 9 for z/OS users of PAIRWISE JOIN.   *
    ****************************************************************
    * PROBLEM DESCRIPTION: A set function query using the pairwise *
    *                      join access method keeps on requesting  *
    *                      storage without freeing it leading to a *
    *                      system storage shortage which can       *
    *                      result in storage manager abends or     *
    *                      failures such as the following.         *
    *                        ABEND04E RC00E20003 from DSNSVBK      *
    *                        ABEND04E RC00E20016 from DSNSVSTK     *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    A set function query using the pairwise
    join access method keeps on requesting
    storage without freeing it leading to a
    system storage shortage which can
    result in storage manager abends or
    failures such as the following.
      ABEND04E RC00E20003 from DSNSVBK
      ABEND04E RC00E20016 from DSNSVSTK
    
    A set function query using the pairwise join access method keeps
    requesting storage without freeing it leading to a system
    storage shortage which can result in various storage manager
    abends or failures.
    
    Specifically, for the problem scenario to occur, the
    pairwise join must meet the following conditions:
    
      1. The FACT Table result rids must be in a workfile.
    
      2. After DB2 evaluates all the FACT Table local predicates
         against the result rids, no qualified rows are found.
    
    In this scenario, the FACT Table's 'first call to fetch' flag or
    'end of file' indicator is not set so DB2 runtime takes a path
    which keeps checking fetch next and keeps on requesting storage
    for the pairwise join.  Eventually, system storage is
    compromised or exhausted which can result in an abend such as
    those mentioned above. Other abends are also possible.
    

Problem conclusion

  • Code is modified in DB2 to set the 'end of file' indicator
    correctly for a pairwise join query which will request only the
    needed amount of storage when it is checked.  This will allow
    the query to complete normally with the expected result and
    prevent any short-on-storage conditions.
    
    Additional Keywords: SQLPAIRWISEJOIN DB2STGLK/K SQLACCESSPATH
                         SQLSETFUNCTION PARALLELISM DB2PARALL/K
                         SQLPARALLELISM
    

Temporary fix

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

Comments

APAR Information

  • APAR number

    PM40789

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-06-03

  • Closed date

    2011-07-29

  • Last modified date

    2011-09-01

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

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

    UK70314

Modules/Macros

  •    DSNXREOJ DSNXRFF  DSNXRGF  DSNXROJ1 DSNXRSFN
    DSNXRSGB DSNXRT1J
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • R910 PSY UK70314

       UP11/08/17 P F108

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.



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for z/OS

Software version:

910

Reference #:

PM40789

Modified date:

2011-09-01

Translate my page

Machine Translation

Content navigation