PI96807: ABEND04E RC00C90101 AT DSNIPSFI ERQUAL5007

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND04E RC00C90101 at DSNIPSFI ERQUAL5007 when running query
  with parallelism
  
  Additional keywords:
  DB2PARALL/K
  

Local fix

• Disable parallelism can bypass the abend
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 11 and 12 for z/OS users of                          *
  * star joins query that uses scalar                            *
  * full select in the comparison and IS                         *
  * NULL predicate.                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Incorrect output may occur for a                             *
  * star joins query containing a                                *
  * comparison or IS NULL                                        *
  * predicate with a scalar                                      *
  * full select.                                                 *
  *                                                              *
  * ABEND04E RC00C90101 at DSNIPSFI                              *
  * ERQUAL5007 may occur for a                                   *
  * star joins query containing a                                *
  * comparison or IS NULL                                        *
  * predicate with a scalar                                      *
  * full select and running with                                 *
  * parallelism.                                                 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTf when available.                         *
  ****************************************************************
  For Example,
  
  SELECT * FROM T1, T2, T3, T4, T5 WHERE
  T1.C1 = T2.C1 AND
  T1.C1 = T3.C1 AND
  T3.C1 = T4.C1 AND
  T4.C1 = T5.C1 AND
  (SELECT T6.C1 FROM T6 WHERE T6.C1 = T4.C1) IS NOT NULL;
  
  ABEND04E RC00C90101 at DSNIPSFI ERQUAL5007 may occur for the
  above SQL statement running with parallelism during star join
  transformation.
  

Problem conclusion

• Db2 was updated to process the scalar full select correctly
  during star join transformation.
  
  Additional Keywords:  SQLSTARJOIN  SQLSCQ SQLISNULL
                        SQLSCALARFULSEL
                        SQLEQUAL SQLISNULL
                        SQLPARALLELISM PARALLELISM
                        DB2PARALL/K  INCORROUT
                        SQLINCORROUT DB2INCORR/KZSA3
  

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:

  UI56953 UI56955

Modules/Macros

• DSNXOSJT
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI56953

     UP18/07/14 P F807 ¢

• RB10 PSY UI56955

     UP18/07/14 P F807 ¢

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.