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

Unfortunately, Dave is starting to sound a little like Steve Richter, trying to find or invent issues that fan the flames of their discontent.

FWIW, I agree with many of the points raised by both of these gentlemen, but after hearing these complaints raised for the billionth time (or so), I begin to avoid these posts. How irritating, to hear complaints of how bad this platform sucks due to missing feature "X", only to learn that it's been there for years. Oh well, on to the next unfounded bash at the system.....

Ahh, I feel better now...

JMHO,
Eric

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of
vhamberg@xxxxxxxxxxx
Sent: Tuesday, February 26, 2008 4:58 PM
To: Midrange Systems Technical Discussion
Subject: Re: Which of the SYSIBM tables/views show the row count for all
PF inthe machine?


Mark

Don't even think of going there! Dave has his own standard of what constitutes an RDBMS, and I disagree, and we are still friends.

We could both be wrong, or, as Tevye says, we are both right!

Vern

-------------- Original message --------------
From: "Mark Allen" <scprideandms@xxxxxxxxx>

WOW, I guess that means the System i (i5/OS) DOES have a "real"
database............

On Tue, Feb 26, 2008 at 12:33 PM, wrote:

SYSPSTAT = SYSPARTITIONSTAT

It was added, via ptf, to V5R4

http://www-1.ibm.com/support/docview.wss?uid=nas26d12eef3dd25b2d6862571ba003c844
0

R540> 3c8440R540>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.