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

A fix is available

Subscribe

You can track all active APARs for this component.

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 number

    PM96352

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-09-04

  • Closed date

    2013-10-08

  • Last modified date

    2013-11-04

  • 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.



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for z/OS

Software version:

910

Reference #:

PM96352

Modified date:

2013-11-04

Translate my page

Machine Translation

Content navigation