Scenario: In a DB2 V8.1 logically partitioned database (4 partitions) on Windows.

The count of the table is as follows:
D:\>db2 "select count(*) from admin.state with ur"

1
-----------
1450000

1 record(s) selected.


D:\>

However, the card from syscat.tables is as follows:

D:\>db2 "select substr(tabname, 1, 30), substr(tabschema,1,30), card, npages, fpages from syscat.tables where tabname like 'STATE%' with ur"

1 2 CARD NPAGES FPAGES
------------------------------ ------------------------------ -------------------- ----------- -----------
STATE ADMIN 40 8 8
STATEMENTS SYSCAT -1 -1 -1

2 record(s) selected.


D:\>

The db2nodes.cfg contents is as found below:

0 pcidl PCIDL 0
1 pcidl PCIDL 1
2 pcidl PCIDL 2
3 pcidl PCIDL 3



How do 1450000 & 40 relate? Why do they not match? Am I missing something in a partitioned database environment?

Thanks in advance.

The stats in the DB2 catalog are only updated after you run runstats.

If the stats are -1, that means that runstats has never been run since the table was created.

Ofcourse, runstats is done, as shown below:

C:\>db2 "select stats_time from syscat.tables where tabname = 'STATE' with ur"

STATS_TIME
--------------------------
2006-07-19-14.24.27.828000

1 record(s) selected.


C:\

In the db2 manuals, about RUNSTATS command :

"The 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.
"

Thanks for the reply.

I have 1 coordinator node and 3 logical partitions on 1 single box.

The partitioning key is on 'bill'. The group by on this key is as follows:
I do not see how 40 is the card value for the above breakup on bill attribute.

Thanks in advance.