IBM Support

LI74161: SCORE() RETURNS WRONG VALUES WITH SYNONYM =ON ON

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Score() returns 0 even when search with SYNONYM ON returns
    result against DB2 V95FP1 - FP3 release
    repro steps
    1. CREATE TABLE T1
       (CLB CLOB(1G),
        AA4 ROWID NOT NULL GENERATED BY DEFAULT
       )CCSID UNICODE;
    2. Insert 10 rows to table T1
       INSERT INTO T1(CLB) VALUES('Sun home for Java. Offers
    Windows, Solaris');
       INSERT INTO T1(CLB) VALUES('Sun home for Java. Offers
    Windows, Solaris');
       INSERT INTO T1(CLB) VALUES('Sun home for Java. Offered
    Windows, Solaris');
       INSERT INTO T1(CLB) VALUES('Sun home for Java. Offers
    Windows, Solaris aufeinanderfolge');
       INSERT INTO T1(CLB) VALUES('Get the latest Java Software and
    explore');
       INSERT INTO T1(CLB) VALUES('Seite fur den manuellen Download
    der Java');
       INSERT INTO T1(CLB) VALUES('Seite fur den manuellen Download
    der Java');
       INSERT INTO T1(CLB) VALUES('Seite fur den manuellen Download
    der Java');
       INSERT INTO T1(CLB) VALUES('Erhalten Sie die C/C++ Version
    von Sun');
       INSERT INTO T1(CLB) VALUES('Erhalten Sie die program
    language Version von Sun');
    3. Create text index on CLB and update it.
       CALL SYSPROC.SYSTS_CREATE('', 'ICLB','T1(CLB)','');
       CALL SYSPROC.SYSTS_UPDATE('', 'ICLB', '');
    4. Create SYNOYM list in the server
    - <synonymgroup>
      <synonym>JAVA</synonym>
      <synonym>C/C++</synonym>
      <synonym>program language</synonym>
      </synonymgroup>
    5. In following query, there should be no value zero returns
    because each sentence at least hits one search keyword.
    db2 => SELECT SUBSTR(CLB,1, 70), SCORE(CLB, 'program
    language', 'SYNONYM=ON') FROM T1 WHERE CONTAINS(CLB, 'program
    language', 'SYNONYM=ON') = 1
    ---------------------------------------------------------------
    ------- ------------------------
    Sun home for Java. Offers Windows, Solaris
       +0.00000000000000E+000  <----score not correct
    Sun home for Java. Offers Windows, Solaris
       +0.00000000000000E+000  <----score not correct
    Sun home for Java. Offered Windows, Solaris
       +0.00000000000000E+000  <----score not correct
    Sun home for Java. Offers Windows, Solaris aufeinanderfolge
       +0.00000000000000E+000  <----score not correct
    Get the latest Java Software and explore
      +0.00000000000000E+000  <----score not correct
    Seite fur den manuellen Download der Java
      +0.00000000000000E+000  <----score not correct
    Seite fur den manuellen Download der Java
      +0.00000000000000E+000  <----score not correct
    Seite fur den manuellen Download der Java
      +0.00000000000000E+000  <----score not correct
    Erhalten Sie die C/C++ Version von Sun
      +1.00000000000000E-002
    Erhalten Sie die program language Version von Sun
      +1.37000000000000E-001
      10 record(s) selected.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * db2 text search on all platforms                             *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * score of db2 text search over synonym returns 0 for some     *
    * match terms.                                                 *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * upgrade to DB2 V9.5 FP4                                      *
    ****************************************************************
    

Problem conclusion

  • DB2 V9.5FP4 has fix for this issue and score on synonym search
    will return value of 0.001 instead of 0
    

Temporary fix

Comments

APAR Information

  • APAR number

    LI74161

  • Reported component name

    DB2 UDE ESE LIN

  • Reported component ID

    5765F4104

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-01-23

  • Closed date

    2009-05-28

  • Last modified date

    2009-05-28

  • 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 UDE ESE LIN

  • Fixed component ID

    5765F4104

Applicable component levels

  • R950 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
28 May 2009