IBM Support

IT07739: DB2 MIGHT ABEND WHEN EXECUTING A QUERY WITH AN EQUALITY PREDICATE

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as fixed if next.

Error description

  • Under rare scenarios, DB2 might abend if the following
    conditions are true:
    1) The query contains one or more comparison predicate(s) in the
    form of Substr(c1, 1, <a_constant>) <relop> <a_constant> where
    <relop> can be =, <>, >=, >, <, <=.
    2) The column c1 of predicate 1) is derived from subquery such
    that its outmost operator is either UNION ALL or GROUP BY.
    3) The subquery of 2) has an output column invovled in an
    equality join predicate.
    
    
    Error:
    
    SQL0901N  The SQL statement failed because of a non-severe
    system error.
    Subsequent SQL statements can be processed.  (Reason "Incorrect
    index: size =
    64 ix = -108.".)  SQLSTATE=58004
    
    Stack trace:
    
    sqlzeDump
    sqlzeSqlCode
    sqlno_add_to_set
    sqlno_assign_after_prds
    sqlno_assign_walk_quns_and_ff
    sqlno_each_opr
    sqlno_assign_walk_quns_and_ff
    

Local fix

  • Manually re-write the query by adding an empty string literal
    using concatenation.
    
    change   WHERE  (Substr(t1.c1, 1, 3) = 'CONTANT')
    to
       WHERE  ( '' + Substr(t1.c1, 1, 3) = 'CONSTANT')
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users                                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Manually re-write the query by adding an empty string        *
    * literal                                                      *
    * using concatenation.                                         *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    IT07739

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2015-03-17

  • Closed date

    2015-10-21

  • Last modified date

    2015-10-21

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

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

Fix information

Applicable component levels

  • R970 PSN

       UP

  • R970 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IT07739

Modified date: 21 October 2015