Question & Answer
Why COLCARD is sometimes bigger than CARD after RUNSTATS?
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.
recycle the instance
16 June 2018