Hello,


I am using DB2 v9 on Windows XP SP 2 and I'm running the following query on SYSIBM.SYSTABLES:
SELECT NAME,CREATOR,CARDF,DBNAME,TSNAME,PARENTS,CHILDREN,CASE WHEN TYPE='T' THEN 'Table' WHEN TYPE='X' THEN 'Auxiliary' WHEN TYPE='G' THEN 'Temporary' END,CREATEDTS,ALTEREDTS,STATSTIME FROM SYSIBM.SYSTABLES WHERE( TYPE='T' OR TYPE='X' OR TYPE='G') ORDER BY 2, 1

I am referring to CARDF property which keeps the count of the rows on a certain table.
The problem is that after I add some rows in table columns (and commit), the CARDF value for it does not update. It returns 0 (-1) no matter how many rows I am adding.
Does anyone know if this sys table gets updated after a certain period of time? Or what is the problem here?




Thanks!

CARDF does not contain "realtime statistic" data.

You need to run the RUNSTATS - utility to update this column

OK thanks!

Also, you should not use sysibm.systables which can change from one release to another. You should use syscat.tables instead which is less likely to change and the contents of which are documented in the SQL Reference Vol 1 Appendix.