× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.