Re: Is there an easy way to list the sizes of all the members of a source PF?

Hi James,

I was trying Marco's & Mark's SQL on v5r4, and found that PARTITION_TEXT does not exist but the rest of it works.

I also joined SYSTABLES and SYSPSTAT in order to select all source files in a given library. I also tried this for all libraries, but it was taking in excess of 30 minutes, so I gave up.

select t.SYSTEM_TABLE_SCHEMA
     , t.SYSTEM_TABLE_NAME
     , p.SYSTEM_TABLE_MEMBER
     , p.DATA_SIZE
     , p.NUMBER_ROWS * p.AVGROWSIZE MBR_SIZE
  from SYSTABLES t
  join SYSPSTAT p
    on t.SYSTEM_TABLE_SCHEMA = p.SYSTEM_TABLE_SCHEMA
   and t.SYSTEM_TABLE_NAME   = p.SYSTEM_TABLE_NAME
 where t.FILE-TYPE = 'S'
   and t.SYSTEM_TABLE_SCHEMA = 'mylib'
order by DATA_SIZE desc

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


/
On 4/19/2021 9:15 AM, James H. H. Lampert wrote:

I'm doing a bit of cleanup, to reclaim some space, and some of the biggest objects I see (according to a DSPOBJD to an outfile) are source PFs.

Obviously, a DSPOBJD to an outfile will give me a file listing the objects in a library, which I can then key on size, but is there something (maybe even something I've used, but forgotten about), to do that for the members of a source PF?

--
JHHL