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

Marco,
Very nice.  

One slight improvement (for James' use case):

SELECT DATA_SIZE, SYSTEM_TABLE_SCHEMA, SYSTEM_TABLE_NAME,         
       SYSTEM_TABLE_MEMBER, PARTITION_TEXT
    FROM QSYS2.SYSPARTITIONSTAT       WHERE TABLE_SCHEMA = 'CHMSRC' AND TABLE_NAME = 'QDDSSRC'
    ORDER BY DATA_SIZE DESC                                                   

Cheers,
Mark S. Waterbury

On Monday, April 19, 2021, 1:41:44 PM EDT, Marco Facchinetti <marco.facchinetti@xxxxxxxxx> wrote:

We use this one:

SELECT SYSTEM_TABLE_SCHEMA,
      SYSTEM_TABLE_NAME,
      SYSTEM_TABLE_MEMBER,
      PARTITION_TEXT,
      DATA_SIZE
    FROM qsys2.SYSPARTITIONSTAT
    WHERE TABLE_SCHEMA = 'MULSRC'
          AND TABLE_NAME = 'QDDSDS ';

HTH
--
Marco Facchinetti

Mr S.r.l.

Tel. 035 962885
Cel. 393 9620498

Skype: facchinettimarco


Il giorno lun 19 apr 2021 alle ore 18:15 James H. H. Lampert <
jamesl@xxxxxxxxxxxxxxxxx> ha scritto:

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
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com