DB2 FOR LUW / DB2FORLUW / A50 - DB2

SQL0156N may be returned when trying to update tables' stats in
SYSSTAT.TABLES catalog table:


db2 "update sysstat.tables set overflow=0 where
tabschema='DB2INST1'"
SQL0156N  The name used for this operation is not a table.
SQLSTATE=42809"


The problem is related with user temporary tables which are not
being taken into account hence causing the error.

The fix would be to include also user temporary tables and
update the stats.

****************************************************************
* USERS AFFECTED:                                              *
* All users on db2 v10.5 FP9 and lower                         *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Db2 v10.5 FP10                                    *
****************************************************************

As a workaroung, temp tables can be omitted from the stats
update:

db2 "UPDATE SYSSTAT.TABLES SET OVERFLOW=0 WHERE
TABSCHEMA='' AND TABNAME IN (SELECT TABNAME FROM
SYSCAT.TABLES WHERE TABSCHEMA='' AND TYPE !='G')"

not known / see Local fix

forerunner  : IT23072 
follow-up : 

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

16.11.2017
11.07.2018
11.07.2018