Hi,

Where can I get a count of the number of rows in a table without having to do a select count(*)? We looked at rowcount column in syscat.systable but it is not reflective of the actual number of rows in a table. is there another column / table to look at?

Thanks,
Toby

If you execute runstats on the table, the information in syscat.systable will be accurate.

I ran 'runstats on table with distribution and indexes all'
but it still gives wrong count.
is there anything wrong?

thanks
toby

are you in a partitioned enviroment.

regards,

mujeeb

The column name in syscat.tables with the rowcount is called CARD.

Yes, I am in partitioned environment.
And I am Querying the CARD column of syscat.tables.

Thanks
toby

RUNSTATS command collects statistics for a table on the database partition from
which it is invoked. If the table does not exist on that database partition, the
first database partition in the database partition group is selected.

Regards,

mujeeb

How do I run runstats on all the partitions?

I usually use db2_all or rah command.

regards,

mujeeb

I am use db2_all.
Ran the runstats using db2_all
db2_all "db2 connect to testdb;db2 runstats on table test_table with distribution and indexes all"

but the counts are still not matching.
select count(*) of table and sysstat.tables' CARD column entry does not match.

Thanks,
toby

How far off is it? Is it a mulitple of the number of partitions?