IBM Support

IC68627: SQL0901N ERROR WHILE DOING A SELECT ON A TABLE WITH A UNION ALL VIEW AS THE NULL PRODUCING SIDE OF A LEFT OUTER JOIN

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • A SQL0901N error is given for a SELECT statement if the
    following conditions are true:
    1. There is a LEFT OUTER JOIN present in the query.
    2. Null producing side of the left outer join is a UNION ALL
    view
    3. There is atleast one range join predicate in the ON clause of
    the left outer join.
    
    Message displayed by DB2 is "FCS Column Descriptor pointer does
    not exist"
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Please see error description                                 *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Please upgrade to DB2 v9.7 fix pack 3                        *
    ****************************************************************
    

Problem conclusion

  • The fix is first provided into DB2 v9.7 fix pack 3
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC68627

  • 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

    2010-05-13

  • Closed date

    2010-09-23

  • Last modified date

    2010-09-23

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

    IC68075

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

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP

  • R970 PSY

       UP

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU029","label":"Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7"}]

Document Information

Modified date:
10 September 2020