IC66613: DB2EXT.TEXTSEARCH(FUZZY FORM OF 80 "99????8" CAUSES LARGE AMOUNTS OF MEMORY TO BE ALLOCATED BUT NOT FREED

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as fixed if next.

Error description

  • Some of the queries using NSE Fuzzy search on numerical/alphanum
    values consumes lot of memory and results in a system hang or
    CTE0104 error. The memory allocated is not freed even after the
    termination of application.
    
    This APAR fix addresses the following:
    
    1.Memory is freed after the query returns with  CTE0104 error.
    2.Reduces the memory consumption in case of Fuzzy search on
    alphanumerical values that contain a combination of SBCS and
    DBCS characters
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL DB2+NSE Users and Content Manager Users                  *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Some of the queries using NSE Fuzzy search on                *
    * numerical/alphanumeric values consumes lot of memory and     *
    * results in a system hang or return CTE0104 error. The memory *
    * allocated is not freed even after the termination of         *
    * application.                                                 *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to IBM DB2 Net Search Extender V.9.5.0.6             *
    ****************************************************************
    Problem Statement:
    Fuzzy search on a numerical/alpha-numerical columns fails with
    CTE0104 error consuming lots of memory. After the error the
    memory allocated is not freed by NSE.
    
    This APAR fixes the above problem by freeing the allocated
    memory after the CTE0104 error.
    

Problem conclusion

  • This APAR fix addresses the following:
    1.Memory is freed after the query returns with CTE0104 error.
    2.Reduces the memory consumption in case of Fuzzy search on
    alphanumerical values that contain a combination of SBCS and
    DBCS characters
    
    The problem is fixed in IBM DB2 Net Search Extender V.9.5.0.6
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC66613

  • Reported component name

    DB2 NET SEARCH

  • Reported component ID

    5765F3800

  • Reported release

    950

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-02-25

  • Closed date

    2010-09-09

  • Last modified date

    2010-09-09

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

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

    IP23023 IC68086 IC68089

Fix information

Applicable component levels

  • R950 PSY

       UP



Rate this page:

(0 users)Average rating

Document information


More support for:

DB2 for Linux, UNIX and Windows
Extenders - Net Search Extender

Software version:

9.5

Reference #:

IC66613

Modified date:

2010-09-09

Translate my page

Machine Translation

Content navigation