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

Thanks Rob/
That explains why I can't find it.
I am on a V5R3M0 system.


Jeff Young
Sr. Programmer Analyst
IBM -e(logo) server Certified Systems Exper - iSeries Technical Solutions V5R2
IBM Certified Specialist- e(logo) server i5Series Technical Solutions Designer V5R3
IBM Certified Specialist- e(logo)server i5Series Technical Solutions Implementer V5R3









----- Original Message ----
From: "rob@xxxxxxxxx" <rob@xxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Sent: Tuesday, February 26, 2008 12:33:01 PM
Subject: Re: Which of the SYSIBM tables/views show the row count for all PF in the machine?

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