|
Problem IC71980
|
Status: Closed |
MISSING SUPPORT "EXLCUDING XML COLUMNS" IN ADMIN_CMD FOR RUNSTAT |
| product: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problem description: |
$ db2 -v "runstats on table ABSINTHE.ATABLE38 for indexes all
excluding xml columns"
runstats on table ABSINTHE.ATABLE38 for indexes all excluding
xml columns
DB20000I The RUNSTATS command completed successfully.
<db2_cobra_aix64_n090217@thegrinch> /home/svtdbm73
$db2 -v "call sysproc.admin_cmd ('runstats on table
ABSINTHE.ATABLE38 for indexes all excluding xml columns')"
<
call sysproc.admin_cmd ('runstats on table ABSINTHE.ATABLE38 for
indexes all excluding xml columns')
SQL0104N An unexpected token "excluding" was found following
"ALL". Expected
tokens may include: "ALLOW". SQLSTATE=42601
admin_cmd for runstats doesnt support the option "excluding xml
columns" while clp runstats supports it. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* DB2FORLUW *
****************************************************************
* PROBLEM DESCRIPTION: *
* db2 -v "runstats on table ABSINTHE.ATABLE38 for indexes all *
* *
* excluding xml columns" *
* *
* runstats on table ABSINTHE.ATABLE38 for indexes all *
* excluding *
* xml columns *
* *
* DB20000I The RUNSTATS command completed successfully. *
* *
* *
* *
* <db2_cobra_aix64_n090217@thegrinch> /home/svtdbm73 *
* *
* $db2 -v "call sysproc.admin_cmd ('runstats on table *
* *
* ABSINTHE.ATABLE38 for indexes all excluding xml columns')" *
* *
* < *
* *
* call sysproc.admin_cmd ('runstats on table ABSINTHE.ATABLE38 *
* for *
* indexes all excluding xml columns') *
* *
* SQL0104N An unexpected token "excluding" was found *
* following *
* "ALL". Expected *
* *
* tokens may include: "ALLOW". SQLSTATE=42601 *
* *
* *
* *
* admin_cmd for runstats doesnt support the option "excluding *
* xml *
* columns" while clp runstats supports it. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to v9.5 fp8 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
First fixed in db2 v9.5 fp8. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 18.10.2010
01.07.2011
01.07.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.5.FP8
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.5.0.8
|
 |
