After running a job watcher monitor and dumping the sql plan cache, our system ASP% grew 10% overnight. I did a RTVDSKINF and located about 125GB of objects in QUSRSYS:
QP0Z482450 *USRSPC QSECOFR .00 311.3 10/05/23 482450/QWQADMIN/TSCOM3

QWQADMIN is IBM DB2 Web Query (which incidentally won't start now).

I think dumping the plan cache might have done this.

There are over 400,000 of these objects related to QWQADMIN. I also see some similar objects from back in 2021 (older system). These appear to be created when traces are run, but never cleaned up.
Regardless, looking for some feedback on deleting these QP0Znnnn objects from QUSRSYS. That library is the second largest on my entire system.

Thanks,
Greg
[Logo]<https://www.totalbizfulfillment.com/> Greg Wilburn
Director of IT
301.895.3792 ext. 1231
301.895.3895 direct
gwilburn@xxxxxxxxxxxxxxxxxxxxxxx<mailto:gwilburn@xxxxxxxxxxxxxxxxxxxxxxx>
1 Corporate Dr
Grantsville, MD 21536
www.totalbizfulfillment.com<http://www.totalbizfulfillment.com>

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.