DB2 FOR LUW / DB2FORLUW / 970 - DB2

The update of statistics of SYSSTAT.COLDIST.COLVALUE generated 
via db2look -m (mimic mode) may fail with SQL0104N error. 
 
The same output looks as follows: 
 
UPDATE SYSSTAT.COLDIST 
SET COLVALUE=''<value>  '', 
      VALCOUNT=<value> 
WHERE COLNAME = '<value>' AND TABNAME = 
'<value>' AND TABSCHEMA = '<SCHEMA>    ' AND TYPE      = 
'<value>' AND SEQNO     =  <value> 
DB21034E  The command was processed as an SQL statement because 
it was not a valid Command Line Processor command.  During SQL 
processing it 
returned: 
SQL0104N  An unexpected token "<value>" was found following 
"DIST SET 
COLVALUE=''".  Expected tokens may include:  "CONCAT". 
SQLSTATE=42601 
 
This occurs because of character wrapping for COLVALUE: db2look 
-m adds 
two single quotes instead of one single quote.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All users on DB2 v97 FP8 and lower                           * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V97 FP9                                       * 
****************************************************************

As a temporary workaround: 
 
 
Remove one single quote for the COLVALUE literal in 
the update statement, then run the statement again: 
 
UPDATE SYSSTAT.COLDIST SET COLVALUE='<value>  ', 
VALCOUNT=<value> WHERE COLNAME = '<value>' AND TABNAME =

DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

First Fixed in DB2 V97 FP9

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC95866 IC95867 IC96371 IC96693 
follow-up : 

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

04.09.2013
17.12.2013
17.12.2013

9.7.FP9