'skew' Tag

  • Record count doesn’t match the CARD in SYSCAT.TABLES

    January 22, 2007

    Ran into this interesting issue today. The count on the table showed only about 118Million rows, but the CARD in syscat.tables showed to have about 1.04 Billion rows. db2 “select count(1) from Schema.tableName” 1 ———– 118697936 1 record(s) selected. db2 “select card from syscat.tables where tabname like ‘tableName’” CARD ——————– 1048386270 1 record(s) selected. RUNSTATS […]

 
Powered by Wordpress and MySQL. Theme by Shlomi Noach, openark.org