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 IC68663 Status: Geschlossen

TABLE NAMES WITH SINGLE QUOTE NOT BEING LISTED BY REORGCHK

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
The table which has been created by the user using the quote in 
the table name is not being listed  by the command  "reorgchk on 
table user". The table gets listed during "CALL 
REORGCHK_TB_STATS('T','USER')". 
Here is a small repro for that - 
 
db2 "CREATE TABLE \"TABLE'S\" (COL1 INTEGER)" 
db2 "INSERT INTO \"TABLE'S\" VALUES (10)" 
db2 "CREATE TABLE \"cccccc\".table2 (COL1 INT, COL2 CHAR(20))" 
db2 "INSERT INTO \"cccccc\".table2 values (10, 'Hello world')" 
 
$ db2 list tables 
 
Table/View Schema Type Creation time 
------------------------------- --------------- ----- 
-------------------------- 
TABLE'S USER T 2009-11-25-03.14.54.752705 
 
1 record(s) selected. 
 
$ db2 list tables for schema \"cccccc\" 
 
Table/View Schema Type Creation time 
------------------------------- --------------- ----- 
-------------------------- 
TABLE2 cccccc T 2009-11-25-03.15.28.893419 
 
1 record(s) selected. 
 
$ db2 "reorgchk on table user" 
 
Doing RUNSTATS .... 
 
 
Table statistics: 
 
F1: 100 * OVERFLOW / CARD < 5 
F2: 100 * (Effective Space Utilization of Data Pages) > 70 
F3: 100 * (Required Pages / Total Pages) > 80 
 
SCHEMA.NAME CARD OV NP FP ACTBLK TSIZE F1 F2 F3 REORG 
---------------------------------------------------------------- 
------------------------ 
---------------------------------------------------------------- 
------------------------ 
 
Index statistics: 
 
F4: CLUSTERRATIO or normalized CLUSTERFACTOR > 80 
F5: 100 * (Space used on leaf pages / Space available on 
non-empty leaf pages) > MIN(50, (100 - PCTFREE)) 
F6: (100 - PCTFREE) * (Amount of space available in an index 
with one less level / Amount of space required for all keys) < 
100 
F7: 100 * (Number of pseudo-deleted RIDs / Total number of RIDs) 
< 20 
F8: 100 * (Number of pseudo-empty leaf pages / Total number of 
leaf pages) < 20 
 
SCHEMA.NAME INDCARD LEAF ELEAF LVLS NDEL KEYS LEAF_RECSIZE 
NLEAF_RECSIZE LEAF_PAGE_OVERHEAD NLEAF_PAGE_OVERHEAD F4 F5 F6 F7 
F8 REORG 
---------------------------------------------------------------- 
---------------------------------------------------------------- 
------------------------------ 
---------------------------------------------------------------- 
---------------------------------------------------------------- 
------------------------------ 
 
CLUSTERRATIO or normalized CLUSTERFACTOR (F4) will indicate 
REORG is necessary 
for indexes that are not in the same sequence as the base table. 
When multiple 
indexes are defined on a table, one or more indexes may be 
flagged as needing 
REORG. Specify the most important index for REORG sequencing. 
 
Tables defined using the ORGANIZE BY clause and the 
corresponding dimension 
indexes have a '*' suffix to their names. The cardinality of a 
dimension index 
is equal to the Active blocks statistic of the table.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* CLP REORGCHK command users                                   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* TABLE NAMES WITH single quote NOT BEING LISTED BY REORGCHK   * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 9.07.200 FP2                                  * 
****************************************************************
Local-Fix:
use admin command REORGCHK_TB_STATS to display the results
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
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 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
use the DB2 v97FP2 to display the table's with single quotes in 
it in REORGHK output
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
17.05.2010
11.06.2010
11.06.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.7.200,
9.7.FP2
Problem behoben lt. FixList in der Version
9.7.0.2 FixList