Re: Which of the SYSIBM tables/views show the row count for all PF in the machine?

[rob@xxxxxxxxx]

SYSPSTAT = SYSPARTITIONSTAT

It was added, via ptf, to V5R4
http://www-1.ibm.com/support/docview.wss?uid=nas26d12eef3dd25b2d6862571ba003c8440
R540 SI27314   7226 

IBM-supplied database views are being added.  These views are 
used to return statistical information of existing database 
objects.  The column names and data in the views are a superset 
of similar statistical views in DB2 for Linux, Unix, and 
Windows. 
 
Views: 
QSYS2.SYSCOLUMNSTAT 
QSYS2.SYSPARTITIONINDEXSTAT 
QSYS2.SYSPARTITIONSTAT 
QSYS2.SYSTABLEINDEXSTAT 
QSYS2.SYSTABLESTAT 
 
Functions: 
QSYS2.COLUMN_STATISTICS 
QSYS2.INDEX_PARTITION_STATISTICS 
QSYS2.PARTITION_STATISTICS 
 
In addition to the new statistical objects, this PTF also: 
- redefines SYSIBM.SQLColPrivileges to be consistent with DB for 
  LUW, by returning table privileges. 
- Add QSYS2.SQLGetAuth Function. 
- Fix a problem where QSYS2 views were incorrectly referring to 
  Functions within SYSIBM. 
Extended description of views: 
SYSCOLUMNSTAT contains one row for every column in a table 
partition or table member and one row for every combination of 
columns from a statistics collection. If the table is a 
distributed table, the partitions that reside on other database 
nodes are not contained in this catalog view. They are contained 
in the catalog views of the other database nodes. 
SYSPARTITIONINDEXSTAT contains one row for every index built 
over a table partition or table member. If the table is a 
distributed table, the indexes over partitions that reside on 
other database nodes are not contained in this catalog view. 
They are contained in the catalog views of the other database 
nodes. 
SYSPARTITIONSTAT contains one row for every table partition or 
table member. If the table is a distributed table, the 
partitions that reside on other database nodes are not contained 
in this catalog view. They are contained in the catalog views of 
the other database nodes. 
SYSTABLEINDEXSTAT contains one row for every index that has at 
least one partition or member built over a table. If the index 
is over more than one partition or member, the statistics 
include all those partitions and members. If the table is a 
distributed table, the partitions that reside on other database 
nodes are not included. They are contained in the catalog views 
of the other database nodes. 
SYSTABLESTAT contains one row for every table that has at least 
one partition or member. If the table has more than one 
partition or member, the statistics include all partitions and 
members. If the table is a distributed table, the partitions 
that reside on other database nodes are not included. They are 
contained in the catalog views of the other database nodes. 

Rob Berendt