|
Problem IC71980
|
Status: Geschlossen |
MISSING SUPPORT "EXLCUDING XML COLUMNS" IN ADMIN_CMD FOR RUNSTAT |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problembeschreibung: |
$ 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-Zusammenfassung: |
****************************************************************
* 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: |
|
| verfügbare FixPacks: |
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
|
| Lösung |
First fixed in db2 v9.5 fp8. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 18.10.2010
01.07.2011
01.07.2011 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.5.FP8
|
| Problem behoben lt. FixList in der Version |
| 9.5.0.8
|
 |
