RE: QPEXDATA cleanup

["Elvis Budimlic" <ebudimlic@xxxxxxxxxxxxxxxxxxxxxxxxx>]

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