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.
ENDPEX command will tell you if there are any active PEX collections.
can end them there.
To figure what member(s) to specify on the DLTPEXDTA you can do
You can run DLTPEXDTA for each member listed under that and other pex
(member names are the same for all pex files).
You could have pex data in other libraries as well. To find those you
WRKOBJ *ALL/QAYP* *FILE
Celebrating 11-Years of SQL Performance Excellence on IBM i5/OS and
Our QPEXDATA library is taking up too much space. I would like to clean
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
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