DB2 - Problembeschreibung
Problem IC73968 | Status: Geschlossen |
THE TABLE EXPLAIN_OBJECT COLUMN DISTINCT RETURNS 0x00 WHEN THE VALUES SHOULD BE Y OR N | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
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-Zusammenfassung: | |
**************************************************************** * 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: | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows | |
Lösung | |
The column will only contain Y or N as described in the documentation. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 19.01.2011 08.04.2011 08.04.2011 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
9.7.0.4 |