IBM Support

IC75971: A REMOTE QUERY WITH BTS SEARCH WILL LEAD TO REMOTE ENGINE CRASH

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • Configure two IDS instances with bts registered. A remote query
    involving search with bts index will make the remote engine to
    crash.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All 11.50 and 11.70 users.                                   *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * An ISTAR query that references a remote table with BTS index *
    * may cause server crash if it has 'bts_contains()' reference  *
    * in its where clause, and 'bts_contains()' is not prefixed    *
    * with remote server specification (e.g.,                      *
    * db@remote:bts_contains(...) will work properly).             *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to 11.50.xC9 or 11.70.xC3.                           *
    ****************************************************************
    

Problem conclusion

  • The problem is fixed in 11.50.xC9 and 11.70.xC3.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC75971

  • Reported component name

    IBM IDS ENTRP E

  • Reported component ID

    5724L2304

  • Reported release

    B15

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-04-22

  • Closed date

    2011-09-27

  • Last modified date

    2011-09-27

  • 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

    IBM IDS ENTRP E

  • Fixed component ID

    5724L2304

Applicable component levels

  • RB15 PSN

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B15","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
27 September 2011