IBM Support

JR30272: USER MAY OBSERVE INCORRECT SCAN RESULT WHEN QUERYING GRAPHIC TYPE COLUMNS

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Index Manager fails to properly initialize a structure that
    containing codepage member passed to the graphic keypart
    comparison routines. As a result trailing blanks in graphic
    strings are not treated as proper codepage data. This results in
    incorrect comparison which in turn causes incorrect index scan
    result. The query ends up not returning the rows containing the
    trailing blanks even tough they satisfy the query conditions.
    This only happens when the IDENTITY collating sequence is used.
    

Local fix

  • Change the IDENTITY collating sequence to the others
    

Problem summary

  • ERROR DESCRIPTION:
    Index Manager fails to properly initialize a structure that
    containing codepage member passed to the graphic keypart
    comparison routines. As a result trailing blanks in graphic
    strings are not treated as proper codepage data. This results in
    incorrect comparison which in turn causes incorrect index scan
    result. The query ends up not returning the rows containing the
    trailing blanks even tough they satisfy the query conditions.
    This only happens when the IDENTITY collating sequence is used.
    
    LOCAL FIX:
    Change the IDENTITY collating sequence to the others
    
    Users affected:
    Users who set IDENTITY collating sequence
    

Problem conclusion

  • Problem was first fixed in DB2 UDB Version 9.5 Fix Pak 3
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR30272

  • Reported component name

    DB2 UDB EXE WIN

  • Reported component ID

    5724E4901

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-08-21

  • Closed date

    2009-03-10

  • Last modified date

    2009-03-10

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

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

    IC65192

Fix information

  • Fixed component name

    DB2 UDB EXE WIN

  • Fixed component ID

    5724E4901

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:
10 March 2009