IBM Support

IC76487: DB2 CAN RETURN SQL0901N WHEN COMPILING SQL STATEMENTS ACCESSING TABLES WITH GENERATED COLUMNS

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • DB2 can return SQL0901N when compiling SQL statements. The error
    code contain the following message:
    
    SQL0901N  The SQL statement failed because of a non-severe
    system error.
    Subsequent SQL statements can be processed.  (Reason "Bad Plan;
    Unresolved QNC
    found".)  SQLSTATE=58004
    
    The SQL statements should meet the following conditions:
    
    1. The SQL statement access tables which contain generated
    columns
    2. The SQL statement has join predicates that reference the
    columns on which the generated column is based
    3. The generated column is not explictly referenced in the SQL
    statement
    

Local fix

  • Add the generated column to the SQL statement.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users running DB2 v9.7 Fix Pack 4 and earlier            *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * DB2 can return SQL0901N when compiling SQL statements. The   *
    * error                                                        *
    * code contain the following message:                          *
    *                                                              *
    *                                                              *
    *                                                              *
    * SQL0901N  The SQL statement failed because of a non-severe   *
    *                                                              *
    * system error.                                                *
    *                                                              *
    * Subsequent SQL statements can be processed.  (Reason "Bad    *
    * Plan;                                                        *
    * Unresolved QNC                                               *
    *                                                              *
    * found".)  SQLSTATE=58004                                     *
    *                                                              *
    *                                                              *
    *                                                              *
    * The SQL statements should meet the following conditions:     *
    *                                                              *
    *                                                              *
    *                                                              *
    * 1. The SQL statement access tables which contain generated   *
    *                                                              *
    * columns                                                      *
    *                                                              *
    * 2. The SQL statement has join predicates that reference the  *
    *                                                              *
    * columns on which the generated column is based               *
    *                                                              *
    * 3. The generated column is not explictly referenced in the   *
    * SQL                                                          *
    * statement                                                    *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 v9.7 Fix Pack 5.                              *
    ****************************************************************
    

Problem conclusion

  • The problem has been fixed in DB2 v9.7 Fix Pack 5.
    

Temporary fix

  • Add the generated column to the SQL statement.
    

Comments

APAR Information

  • APAR number

    IC76487

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-05-19

  • Closed date

    2011-11-09

  • Last modified date

    2011-11-09

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

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

    IC76640

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC76487

Modified date: 09 November 2011