Elvis,

Thanks. That was very helpful.

I found one difference, perhaps due to release. I am using V5R4. I found
that the file QAYPEASPI did not exist but the file QAYPETIDX could be
used as you described.

WRKMBRPDM QPEXDATA/QAYPETIDX

Thanks again,
-Marty

-----Original Message-----

ENDPEX command will tell you if there are any active PEX collections.
You
can end them there.

To figure what member(s) to specify on the DLTPEXDTA you can do
something
like:

WRKMBRPDM QPEXDATA/QAYPEASPI

You can run DLTPEXDTA for each member listed under that and other pex
files
(member names are the same for all pex files).

You could have pex data in other libraries as well. To find those you
could
do:

WRKOBJ *ALL/QAYP* *FILE

HTH, Elvis

Celebrating 11-Years of SQL Performance Excellence on IBM i5/OS and
OS/400
www.centerfieldtechnology.com

-----Original Message-----
Subject:

Our QPEXDATA library is taking up too much space. I would like to clean
it up.

I see the DLTPEXDTA command, but I do not know the name of any of the
collections that have been saved. I don't want to corrupt the PEX
database by attempting to manually delete things. Is there a way I can
detemine what collections are in the database so I can use DLTPEXDTA to
get rid of them?

We don't use PEX often so I don't really have to worry about stepping on
anybody's toes.

Thanks,
-Marty

This thread ...


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].