RE: QPEXDATA cleanup -- MIDRANGE-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

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: QPEXDATA cleanup

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 mailing list archive is Copyright 1997-2024 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].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.