debugging tuning queries via iseries navigator tom mckinley mac2@us ibm com n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Debugging/Tuning Queries via iSeries Navigator Tom McKinley Mac2@us.ibm.com PowerPoint Presentation
Download Presentation
Debugging/Tuning Queries via iSeries Navigator Tom McKinley Mac2@us.ibm.com

Loading in 2 Seconds...

play fullscreen
1 / 19

Debugging/Tuning Queries via iSeries Navigator Tom McKinley Mac2@us.ibm.com - PowerPoint PPT Presentation


  • 94 Views
  • Uploaded on

Debugging/Tuning Queries via iSeries Navigator Tom McKinley Mac2@us.ibm.com. Tour . What’s info is available System Monitoring Collection Services Work Management Table Show Indexes Index Advisor (DB, Schema or table level) BETA ONLY, removed from presentation. Stats .

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Debugging/Tuning Queries via iSeries Navigator Tom McKinley Mac2@us.ibm.com' - kilenya


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
slide2
Tour
  • What’s info is available
    • System Monitoring
    • Collection Services
    • Work Management
    • Table
    • Show Indexes
    • Index Advisor (DB, Schema or table level) BETA ONLY, removed from presentation.
    • Stats
other sources of info
Other sources of Info
  • DB2 for iSeries Web Site
    • http://www-03.ibm.com/servers/eserver/iseries/db2/
  • Monitor queries
    • http://www-03.ibm.com/servers/eserver/iseries/db2/dbmonqrys.htm
  • White papers
    • http://www-03.ibm.com/servers/eserver/iseries/db2/awp.html
  • SQL performance and query optimization guide (Info Center)
  • Common, Tech Conferences…
  • Query Performance tuning workshop
    • http://www-03.ibm.com/servers/eserver/iseries/service/igs/db2performance.html
summary
Summary
  • Many things affect query plans
  • Try to understand the access methods
  • Learn the tools
  • Size matters
    • “Bad Performance does not scale”.
  • You need to collect info before you make changes to help understand what changed and the impact of that change.
  • Don’t only focus on Runtime. Look for resource hogs, or for queries that are run frequently
  • Good indexing strategy in some cases is critical