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 | |
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 |