home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC82121 Status: Geschlossen

THE PCTINLINED COLUMN IN THE SYSIBM.SYSCOLUMNS TABLE DOES NOT GE T UPDATED
EVEN THOUGH DB2CAT SHOWS THE XML STATS ARE COLLECTED

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
Here is the output from sysibm.syscolumns for the PCTINLINED 
column 
db2 "select substr(NAME,1,25) as NAME, substr(TBNAME,1,30) as 
TABLENAME,substr(TBCREATOR,1,25) as SCHEMA, PCTINLINED from 
sysibm.syscolumns where TBNAME='CONDITIONS' and 
TBCREATOR='DMIW'" 
NAME                      TABLENAME                      SCHEMA 
PCTINLINED 
------------------------- ------------------------------ 
------------------------- ---------- 
XCONDITIONS               CONDITIONS                     DMIW 
-1 
 
  1 record(s) selected. 
 
Even though db2cat shows it does collect the statistics 
 
++++++++++++++++++++++++++++++++++++++++ 
XML column statistics 
++++++++++++++++++++++++++++++++++++++++ 
Column ID            = 3 
No. NULL XML docs    = 0 
No. non-NULL XML docs = 44 
Smallest XML doc size = 420 
Largest XML doc size  = 1052 
Avg XML doc size      = 489 
No. inlined docs      = 44 
---------------------------------------- 
Catch All Pathid Bucket 
---------------------------------------- 
Distinct Pathid count = 47 
Sum Node Counts       = 665 
Sum Doc Counts        = 546 
--- 
---
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Problem Description Above.                               * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version V9.7 Fixpack FP7                      * 
****************************************************************
Local-Fix:
NONE, Use the db2cat output to validate the XML statistics are 
collected.  The PCTLINED is inaccurate without this fix.
verfügbare FixPacks:
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

Lösung
First Fixed in Version V9.7 Fixpack FP7
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC87886 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
19.03.2012
29.01.2013
29.01.2013
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FPFP7
Problem behoben lt. FixList in der Version
9.7.0.7 FixList