IBM Support

IT07729: DB2 MIGHT ABEND OR PRODUCE SQL0901N WHEN EXECUTING QUERY WITH LIKE PREDICATE IN ORA MODE

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 when the following
    conditions are true:
    1) DB2 is running with DB2_COMPATIBILITY_VECTOR=ORA
    2) The query contains one or more LIKE predicates
    3) The query contains a UNION with at least 2 branches.
    4) The column referenced in the LIKE predicate is of datatype
    CHAR/GRAPHIC
    5) The same column is also referenced in the output columns of
    the UNION ALL branches and is a complex expression with a
    resulting datatype of VARCHAR/VARGRAPHIC in at least one branch.
    
    
    You may see the following in the trap file:
    
    <POFDisassembly>
     _ZNK9sqlnq_pid2opEv + 0x0000
    
    </POFDisassembly>
    <StackTrace>
    -----FUNC-ADDR---- ------FUNCTION + OFFSET------
    

Local fix

  • Explicitly cast the LIKE predicate column to be of type VARCHAR
    or VARGRAPHIC
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * V9.7                                                         *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Explicitly cast the LIKE predicate column to be of type      *
    * VARCHAR                                                      *
    * or VARGRAPHIC                                                *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    IT07729

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

  • Closed date

    2015-10-15

  • Last modified date

    2015-10-15

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

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

    IT11656

Fix information

Applicable component levels

  • R970 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IT07729

Modified date: 15 October 2015