invispix 10x10
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IT38969 Status: Closed

WRONG STRING COMPARISON FOR THAI NLSCHAR DATABASE COULD HAPPEN

product:
DB2 FOR LUW / DB2FORLUW / B10 - DB2
Problem description:
In the database created with this codepage and collation
NLSCHAR:
create db  USING CODESET TIS620-1 TERRITORY TH COLLATE
USING NLSCHAR

Incorrect comparison between char strings could happen.
It can also lead to bad order.
Indexes could be affected. Please use 'db2dart ' to
identify any
affected indexes.
After this fix is installed all affected indexes need to be
recreated.  Indexes can also be rebuilt using REORG INDEXES.

Example of the problem issue:
create table test1 (c1 char(50),c2 char(50));

insert into test1 values
(
x'E0202020202020202020202020202020202020202020202020202020202020
20202020202020202020202020202020202020',
x'E0FB2020202020202020202020202020202020202020202020202020202020
20202020202020202020202020202020202020'
);
insert into test1 values
(
x'E0FB2020202020202020202020202020202020202020202020202020202020
20202020202020202020202020202020202020',
x'E0202020202020202020202020202020202020202020202020202020202020
20202020202020202020202020202020202020'
);

and one see different ordering with c1 and c2:

db2 "select hex(c1) from test1 order by c1"

1

----------------------------------------------------------------
------------------------------------
E020202020202020202020202020202020202020202020202020202020202020
202020202020202020202020202020202020
E0FB202020202020202020202020202020202020202020202020202020202020
202020202020202020202020202020202020

  2 record(s) selected.

db2 "select hex(c2) from test1 order by c2"

1

----------------------------------------------------------------
------------------------------------
E0FB202020202020202020202020202020202020202020202020202020202020
202020202020202020202020202020202020
E020202020202020202020202020202020202020202020202020202020202020
202020202020202020202020202020202020

  2 record(s) selected.
Problem Summary:
****************************************************************
* USERS AFFECTED:                                              *
* THAI NLSCHAR DATABASE only                                   *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description, install this fix                      *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to 11.1.4.7                                          *
****************************************************************
Local Fix:
N/A
Please, install this fix and re-create indexes affected.
Solution
Workaround
****************************************************************
* USERS AFFECTED:                                              *
* THAI NLSCHAR DATABASE only                                   *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description, install this fix                      *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to 11.1.4.7                                          *
****************************************************************
Comment
Upgrade to 11.1.4.7
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
04.11.2021
17.04.2022
20.04.2022
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
invispix 10x10
invispix 10x10
Versions InfomailVersions Infomail

Versions Infomail

Product LifecycleProduct Lifecycle

Lifecycle

Current BugsCurrent Bugs

Current Bugs

Bug ResearchBug Research

Bug Research

Bug FixlistsBug Fixlists

Bug Fixlists

invispix 10x10