|
Problem IC68663
|
Status: Closed |
TABLE NAMES WITH SINGLE QUOTE NOT BEING LISTED BY REORGCHK |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* 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 |
| available fix packs: |
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
|
| Solution |
use the DB2 v97FP2 to display the table's with single quotes in
it in REORGHK output |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 17.05.2010
11.06.2010
11.06.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.7.200,
9.7.FP2
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.2
|
 |
