PI84532: ABEND04E RC00E70005 DSNXRSBC P041 WHEN PARALLELISM IS ENABLED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND04E RC00E70005 DSNXRSBC P041 when parallelism is enabled .
  

Local fix

• Disable parallelism .
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 11 for z/OS users of an SQL          *
  *                 statement containing a TRIM or STRIP         *
  *                 function in the table expression or view on  *
  *                 the null padding side of an outer join.      *
  ****************************************************************
  * PROBLEM DESCRIPTION: ABEND04E RC00E70005 at the location     *
  *                      DSNXGRDS DSNXRSBC P041 could happen     *
  *                      for an SQL statement satisfying all     *
  *                      of the following conditions:            *
  *                                                              *
  *                      1. It contains an outer join and a      *
  *                         table expression or view.            *
  *                      2. The table expression or view is      *
  *                         on the null padding side of the      *
  *                         outer join.                          *
  *                      3. A TRIM or STRIP function is in       *
  *                         the select list of the table         *
  *                         expression or view.                  *
  *                      4. Parallelism is enabled.              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  An example is shown below:
  
  CREATE TABLE T1(
    C1 CHAR(10) NOT NULL
  , C2 CHAR(10) NOT NULL
                 )
  ;
  CREATE TABLE T2(
    C1 CHAR(10) NOT NULL
  , C2 CHAR(10) NOT NULL
                 )
  ;
  
  SELECT *
  FROM T1 LEFT OUTER JOIN
    (SELECT TRIM(C1) AS C1, C2
     FROM T2
    ) TX(C1, C2) ON T1.C1 = TX.C2
  ;
  
  DB2 did not correctly process the aforementioned SQL statement,
  and resulted in the ABEND.
  

Problem conclusion

• DB2 has been modified to correctly process the aforementioned
  SQL statement.
  
  Additional keywords: SQLTABLEEXPR SQLVIEW SQLOUTERJOIN
                       SQLFULLJOIN SQLOUTER SQLFULL SQLJOIN
                       SQLLEFTJOIN SQLLEFT SQLRIGHTJOIN SQLRIGHT
                       SQLPARALLELISM  DB2PARALL/K
  

Temporary fix

Comments

APAR Information

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

  PI83813

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

  UI49379

Modules/Macros

• DSNXOSCF
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RB10 PSY UI49379

     UP17/08/24 P F708

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.