SAP Knowledge Base Article - Preview

2867808 - Reverse of DB2 tables with statistics fails with error SQL802N

Symptom

  • Reverse engineering of tables with statistics fails with error SQLN802N.
  • The Output displays:

Start update of statistics...
SQLSTATE = 22003
DB2 SQL Error: SQLCODE=-802, SQLSTATE=22003, SQLERRMC=null, DRIVER=3.72.44
Table owner_name.table_name Failed
Cannot update statistics for Table owner_name.table_name


Read more...

Environment

  • SAP PowerDesigner (PD) 16.6
  • IBM DB2 for Linux, UNIX, and Windows

Product

SAP PowerDesigner 16.6

Keywords

db2mvs, mvs, db2udb, udb, luw, number, integer, character, cardinality, range, cast , KBA , BC-SYB-PD , PowerDesigner , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.