Frequently Asked Questions
* NEW *
Free AS400 App Monitoring
Free 1 Year Pro License Offer
Topics
Send Email
00069 - How do I run the Query Optimizer data collector? (95)
1) EZRAD WORKPERF
2) option 9
3) find QUERYOPT job on *HOLD
4) 2=Change
5) change hours=1 parameter to desired setting
6) change limit=1 parameter to control allowed gigabytes of temporary disk space
7) set Frequency to *ONCE
8) enter Schedule Date in system format with slashes and leading zeros
9) enter *NONE for Schedule Day
10) enter Schedule Time in system format with colons and leading zeros
11) press ENTER
12) could have left on *HOLD and used 1=Start now

Be careful on Production systems

This process uses STRDBMON *ALL command and can impact performance.

ENDJOB QUERYOPT *IMMED if an issue.