Just so this thread mentions it, TAATOOL has RTVPFA (retrieve PF attributes) that has both MBRS (number of members in the file) and MAXMBRS (max members for the file) as parameters. It uses the DSPFD to outfile method mentioned earlier.

--
*Peter Dow* /
Dow Software Services, Inc.
909 793-9050
petercdow@xxxxxxxxx <mailto:petercdow@xxxxxxxxx> /

On 4/2/2012 10:34 AM, rob@xxxxxxxxx wrote:
You mean something like:

select system_table_sCHEMA, SYSTEM_TABLE_NAME, NUMBER_PARTITIONS
FROM SYSTSTAT WHERE SYSTEM_TABLE_SCHEMA='ROB'

Haven't found a Max_Number_Partitions column yet. Just don't have time to
write a function to use this:
http://publib.boulder.ibm.com/infocenter/iseries/v7r1m0/topic/apis/qdbrtvfd.htm
Qdbfhmxm Maximum members (MAXMBRS).
Qdbfhmnum Number of members, 0 through 32,767


Rob Berendt

This thread ...

Replies:

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

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