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

Good News Everybody!

The new search engine is LIVE!

Please report any problems to david (at) midrange.com.

Subject: Re: Which of the SYSIBM tables/views show the row count for all PF in the machine?
From: vhamberg@xxxxxxxxxxx
Date: Tue, 26 Feb 2008 22:57:40 +0000
List-archive: <http://archive.midrange.com/midrange-l>
List-help: <mailto:midrange-l-request@midrange.com?subject=help>
List-id: Midrange Systems Technical Discussion <midrange-l.midrange.com>
List-post: <mailto:midrange-l@midrange.com>
List-subscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=subscribe>
List-unsubscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=unsubscribe>

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.

As an Amazon Associate we earn from qualifying purchases.

Follow-Ups:

RE: Which of the SYSIBM tables/views show the row count for all PF inthe machine? , DeLong, Eric
Re: Which of the SYSIBM tables/views show the row count for all PF in the machine? , Mark Allen

This mailing list archive is Copyright 1997-2026 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.