|
Problem IC88634
|
Status: Closed |
DB2LOOK & SYSDATAPARTITIONS(LOWVALUE & HIGHVALUE) CAN PRODUCE INCORRECT STRING REPRESENTATION FOR PARTITIONING RANGE VALUES. |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
db2look & SYSDATAPARTITIONS(LOWVALUE & HIGHVALUE) can produce
incorrect string representation for partitioning range values.
This issue has only been see using "FOR BIT DATA" on the DATA
PARTITIONS columns.
Example:
create table t1 (c1 varchar(4) for bit data not null) partition
by range (c1) (part p0 starting (X'00000000'), part p1 starting
(X'10000000'), part p2 starting (X'20000000') ending
(X'FFFFFFFF'))
P0 (X'00000000 - X'0FFFFFFF)
P1 (X'10000000 - X'1FFFFFFF)
P2 (X'20000000 - X'FFFFFFFF)
Proposal:
create table t1 (c1 varchar(4) for bit data not null) partition
by range (c1) (part p0 starting MINVALUE inclusive ending
(X'0FFFFFFF') inclusive, part p1 starting (X'0FFFFFFF')
exclusive ending (X'1FFFFFFF') inclusive, part p2 starting
(X'1FFFFFFF') exclusive ending (X'FFFFFFFF'))
P0 (MINVALUE - X'0FFFFFFF)
P1 (X'10000000 - X'1FFFFFFF)
P2 (X'20000000 - X'FFFFFFFF) |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All Platforms *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to v10.1 Fixpack 2 or higher *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Solution |
First Fixed in v10.1 Fixpack 2 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 28.11.2012
09.01.2013
09.01.2013 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.2
|
 |
| 10.5.0.2
|
|
