|
_i5/OS catalog tables and views_
The i5/OS™ catalog includes the following views and tables in the QSYS2
schema:
http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/db2/rbafzmstcatalogtbls.htm#catsyststat
"
SYSTABLESTAT
The SYSTABLESTAT view contains one row for every table that has at least
one partition or member...
"
The short name for that file is SYSTSTAT. I believe the standard members
are found where PARTITION_TYPE /* for PARTTYPE= '' */ is blank; i.e. The
table is not partitioned. The NUMBER_PARTITIONS for NBRPARTS gives the
number of members.
In that same page of documentation is the SYSPARTITIONSTAT [SYSPSTAT]
catalog VIEW which gives specifics about each member. These are
implemented with an external UDTF, presumably implemented using the
QDBRTVFD and QUSLMBR and\or QUSRMBRD [or equivalent OS requests] to get
the information from the database *FILE and database file members.
Some more discussion... The thread or these specific messages from the
thread with Subject: "Which of the SYSIBM tables/views show the row
count for all PF in the machine?"
http://archive.midrange.com/midrange-l/200802/msg01218.html
http://archive.midrange.com/midrange-l/200802/msg01242.html
Regards, Chuck
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 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.
midrange.com
