IBM Support

IT35581: SEGV OCCURS WHILE PREPARING A QUERY WITH AN XML PREDICATE THAT CONTAINS ANY EMPTY STRING LITERAL, RESULTS IN SQL1224N.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The segv/trap occurs when:
    The XML search condition includes an empty string e.g.
    /book[price=""]
    /book[price>""]
    /book[price/text()!=""]
    
    An XML index with DOUBLE data type exists on the expression used
    in the predicate e.g. CREATE INDEX <indname> ON
    bookstore(bookdetails) GENERATE KEY USING XMLPATTERN
    '/book/price' AS SQL double;
    XML histogram statistics exist for the expression used in the
    predicate and the index. XML statistics are not visible in the
    system catalog views so db2cat must be used to display them.
    
    
    The trap is sustainable. The application will receive:
    
    SQL1224N The database manager is not able to accept new
    requests,
    has terminated all requests in progress, or has terminated the
    specified
    request because of an error or a forced interrupt.
    SQLSTATE=55032
    
    The stack trace will include
    sqlno_xml_stats_interface11convLiteral
    

Local fix

  • Either of these approaches will avoid the trap:
    - Exclude XML statistics by issuing RUNSTATS with the EXCLUDING
    XML COLUMNS clause
    - Drop the index on the XML expression
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * all                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * The segv/trap occurs when:                                   *
    * The XML search condition includes an empty string e.g.       *
    * /book[price=""]                                              *
    * /book[price>""]                                              *
    * /book[price/text()!=""]                                      *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to db2_v111m4fp7 or v11.5(already fixed).            *
    ****************************************************************
    

Problem conclusion

  • First fixed in db2_v111m4fp7
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT35581

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2021-01-19

  • Closed date

    2021-09-02

  • Last modified date

    2021-09-02

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

  • 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

  • RB10 PSN

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
04 May 2022