|
Problem IT23072
|
Status: Closed |
SQL0156N WHEN UPDATING STATISTICS IN SYSSTAT.TABLES |
| product: |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 |
| Problem description: |
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. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All Users on DB2 v111m2fp2 *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 v111m3fp3 *
**************************************************************** |
| Local Fix: |
As a workaroung, temp tables can be omitted from the stats
update:
db2 "UPDATE SYSSTAT.TABLES SET OVERFLOW=0 WHERE
TABSCHEMA='<tabschema>' AND TABNAME IN (SELECT TABNAME FROM
SYSCAT.TABLES WHERE TABSCHEMA='<tabschema>' AND TYPE !='G')" |
| available fix packs: |
Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix002 for Linux, UNIX, and Windows
|
| Solution |
First Fixed in DB2 v111m3fp3 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 07.11.2017
15.03.2018
15.03.2018 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
