Frequently Asked Questions
* NEW *
Free AS400 App Monitoring
Free 1 Year Pro License Offer
Topics
Send Email
00269 - Can I improve SQL performance without having access to source code? (27)
Yes. Use the IBM commands STRDBMON and ENDDBMON to collect SQL performance statistics. Analyze this output file to gather data on the worst performing SQL requests. Build new indexes or logical files recommended by the operating system. Our Query Optimizer automates this data collection process.