|
Problem IC73968
|
Status: Closed |
THE TABLE EXPLAIN_OBJECT COLUMN DISTINCT RETURNS 0x00 WHEN THE VALUES SHOULD BE Y OR N |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
The table EXPLAIN_OBJECT contains a column DISTINCT. The
excerpt below from the manual SQL Ref Vol 1 appendix I states:
that it may contain the values "Y" or "N"
DISTINCT CHAR(1) No No Indicates whether the rows in the object
are distinct (that is, whether there are duplicates).
Possible values are:
Y Yes
N No
In some cases of special objects, it can contain 0x00.
db2 => select object_name, object_type, hex(xj.distinct)
db2 (cont.) => from explain_object xj where distinct <> 'Y' and
distinct <> 'N'
db2 (cont.) => @
OBJECT_NAME OBJECT_TYPE 3
-------------------------- ----------- --
CCST_CLAIM +T 00
CCST_MATTER +T 00
CCST_CLAIMCONTACT +T 00
CCST_ACTIVITY +T 00
CCST_EXPOSURE +T 00
CC_CLAIM +T 00
CC_MATTER +T 00
CC_CLAIMCONTACT +T 00
CC_ACTIVITY +T 00
CC_EXPOSURE +T 00
10 record(s) selected. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* THE TABLE EXPLAIN_OBJECT COLUMN DISTINCT RETURNS 0x00 WHEN *
* THE *
* VALUES SHOULD BE Y OR N *
****************************************************************
* PROBLEM DESCRIPTION: *
* The table EXPLAIN_OBJECT contains a column DISTINCT. The *
* *
* excerpt below from the manual SQL Ref Vol 1 appendix I *
* states: *
* that it may contain the values "Y" or "N" *
* *
* *
* *
* DISTINCT CHAR(1) No No Indicates whether the rows in the *
* object *
* are distinct (that is, whether there are duplicates). *
* *
* *
* *
* Possible values are: *
* *
* Y Yes *
* *
* N No *
* *
* *
* *
* In some cases of special objects, it can contain 0x00. *
* *
* *
* *
* db2 => select object_name, object_type, hex(xj.distinct) *
* *
* db2 (cont.) => from explain_object xj where distinct <> 'Y' *
* and *
* distinct <> 'N' *
* *
* db2 (cont.) => @ *
* *
* *
* *
* OBJECT_NAME OBJECT_TYPE 3 *
* *
* -------------------------- ----------- -- *
* *
* CCST_CLAIM +T 00 *
* *
* CCST_MATTER +T 00 *
* *
* CCST_CLAIMCONTACT +T 00 *
* *
* CCST_ACTIVITY +T 00 *
* *
* CCST_EXPOSURE +T 00 *
* *
* CC_CLAIM +T 00 *
* *
* CC_MATTER +T 00 *
* *
* CC_CLAIMCONTACT +T 00 *
* *
* CC_ACTIVITY +T 00 *
* *
* CC_EXPOSURE +T 00 *
* *
* *
* *
* 10 record(s) selected. *
****************************************************************
* RECOMMENDATION: *
* Apply this fix. *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
The column will only contain Y or N as described in the
documentation. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 19.01.2011
08.04.2011
08.04.2011 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.4
|
 |
