3704166 - DB6: Check NPAGE, FPAGE and CARD values of a table - How To

Symptom

Table has been newly created and the value of NPAGE, FPAGE and CARD are showing '-1', however the table itself has rows.
NPAGE - number of pages that a table (or index) occupies on disk. Each page holds a certain number of rows or index entries.
FPAGE - first page of a table or index,(starting page in the table’s or index’s storage structure).
CARD - cardinality, (number of rows (records) in the table or the number of entries in an index).

Environment

Db2 LUW IBM

Product

SAP ERP 6.0

Keywords

cardinality, optimizer, catalog, metadata, estimate, performance, history

, KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , How To

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.