Latest versionsfixlist
11.1.0.6 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
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26
Question in the chat LiveZilla Live Help

DB2 - Problem description

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 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.