IT23072: SQL0156N WHEN UPDATING STATISTICS IN SYSSTAT.TABLES

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
Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 5 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 7 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error 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.
  

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')"
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users on DB2 v111m2fp2                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to DB2 v111m3fp3                                     *
  ****************************************************************
  

Problem conclusion

• First Fixed in DB2 v111m3fp3
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  IT23198

Fix information

• Fixed component name

  DB2 FOR LUW

• Fixed component ID

  DB2FORLUW

Applicable component levels

• RB10 PSY

     UP