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:
Qdbfhmxm Maximum members (MAXMBRS).
Qdbfhmnum Number of members, 0 through 32,767