PM96352: ABEND04E RC00C90101 AT DSNIBNRF ERQUAL 501E ON V9 WHEN EXPLAIN WITH V10 PLAN_TABLE AND NEW V10 COLUMNS WITHOUT 'WITH DEFAULT'

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• 04E abend with reason code 00C90101 occurs when run EXPLAIN on
  V9 with V10 PLAN_TABLE that contains new V10 columns that are
  defined without the WITH DEFAULT clause. For example
  
   BIND_EXPLAIN_ONLY  CHAR(1)      NOT NULL  --- this is a V10
  column, defined without WITH DEFAULT
  

Local fix

• Add WITH DEFAULT clause to those columns or delete those new V10
  columns.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 for z/OS users of EXPLAIN            *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using EXPLAIN and:                 *
  *                                                              *
  *                       - The explain tables are in a release  *
  *                         format that is newer than the        *
  *                         release of DB2 that is currently     *
  *                         running                              *
  *                                                              *
  *                       - One or more new columns that require *
  *                         the WITH DEFAULT clause were not     *
  *                         defined with this clause             *
  *                                                              *
  *                      the following symptom may occur:        *
  *                                                              *
  *                      ABEND04E RC00C90101 in DSNIBNRF         *
  *                      ERQUAL501E                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When using EXPLAIN and:
  
   - The explain tables are in a release format that is newer than
     the release of DB2 that is currently running
  
   - One or more new columns that require the WITH DEFAULT clause
     were not defined with this clause
  
  the following symptom may occur:
  
  ABEND04E RC00C90101 in DSNIBNRF ERQUAL501E
  
  Example:
  
  In V10, PLAN_TABLE added column MERGN. If the V10 PLAN_TABLE is
  created on a V9 system and MERGN is declared without the
  required WITH DEFAULT clause, then the abend may occur.
  
  The above problem was caused by program error.
  
  Additional keywords:
  
  ABEND04E RC00C90101 ERQUAL501E SQLEXPLAIN
  

Problem conclusion

• DB2 code has been changed to check the column default for
  explain tables before inserting into them. In the example above,
  SQLCODE -220 will be issued for the incorrect PLAN_TABLE
  definition instead of abending.
  

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:

  UK98304 UK98305 UK98306

Modules/Macros

• DSNXOD0  DSNXOD0A DSNXOD0I DSNXOD0P DSNXOD0Z
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK98304

     UP13/10/25 P F310

• RB10 PSY UK98305

     UP13/10/25 P F310

• R910 PSY UK98306

     UP13/10/25 P F310

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.