IBM Support

Why COLCARD is sometimes bigger than CARD after RUNSTATS?

Technote (FAQ)


Question

Why COLCARD is sometimes bigger than CARD after RUNSTATS?

Answer

This symptom is normal if new rows are inserted into the table during runstats. User can try runstats with "ALLOW READ ACCESS" option. This will block any modification to the table during runstats. But, in production environment, it is usually undesirable to block writing to the table, especially if runstats takes a long time.
Starting from v97fp9, for the purpose of mimic statistics in test environment, db2 has an undocumented registry, when set, it will allow "UPDATE SYSSTAT" to go through even if the statistics are inconsistent.

db2set DB2_STATISTICS=USCC:0
recycle the instance

Document information

More support for: DB2 for Linux, UNIX and Windows
Compiler - Runstats

Software version: 9.7, 9.8, 10.1, 10.5

Operating system(s): AIX, HP-UX, Linux, Solaris, Windows

Reference #: 1985376

Modified date: 14 June 2016


Translate this page: