PM80074: ABEND04E RC00E70005 DSNXRPJP M558 RUNNING A JOIN WITH PARALLELISM

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND04E RC00E70005 running a join with parallelism active.
  Abend occurs in DSNXRPJP at logical offset M558
  Abend is preceded by a negative SQLCODE (unknown).  A second
  attempt running the SQL statement provides success.
  

Local fix

• Disable Parallelism
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: DB2 9 for z/OS and DB2 10 for z/OS           *
  *                 users of pair-wise join query with           *
  *                 the dynamic statement cache enabled          *
  *                 (CACHEDYN = YES)                             *
  ****************************************************************
  * PROBLEM DESCRIPTION: An ABEND04E RC00E70005 at DSNXRPJP      *
  *                      M558 may occur when a pair-wise join    *
  *                      query is executed multiple times and    *
  *                      the SQL statement is cached and the     *
  *                      previous execution of the SQL statement *
  *                      returned a negative sqlcode.            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  An ABEND04E RC00E70005 at DSNXRPJP M558 may occur when a pair-
  wise join query is executed multiple times in a system with the
  dynamic statement cache enabled (CACHEDYN = YES) and the
  previous execution returned a negative SQLCODE. After a negative
  SQLCODE is issued, a certain variable was not reset in this
  access path, allowing for subsequent executions of the statement
  to receive this error.
  
  The problem can apply to all pair-wise join queries, if and
  only if the pair-wise join query
  1. is executed multiple times and
  2. the system SQL dynamic statement cache is enabled
     (CACHEDYN = YES) and
  3. a negative sqlcode is returned in previous execution of the
     same statement.
  

Problem conclusion

• DB2 is modified to re-initialize the variable properly before
  pair-wise join is executed.
  
  Additional Keywords: SQLPAIRWISEJOIN SQLDYNSTMTCACHE ABEND04E
                       RC00E70005 DB2PARALL/K
  

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:

  UK91885 UK91886

Modules/Macros

•    DSNXRPJP
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK91885

     UP13/03/08 P F303

• R910 PSY UK91886

     UP13/03/08 P F303

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.