InfoSphere Optim Query Workload Tuner

This page has not been liked. Updated 7/11/13 8:56 AM by robertsamuelTags: None

About

IBM InfoSphere Optim Query Workload Tuner for DB2 for Linux, UNIX and Windows provides expert recommendations to help you improve the performance of query workloads. It can help you optimize application performance, reduce the need for specialized skills and lower total cost of ownership and now includes advise for the new DB2 for Linux, UNIX and Windows 10.5 column-organized tables.

InfoSphere Optim Query Workload Tuner for DB2 for Linux, UNIX and Windows helps you:

Videos

  1. Create RUNSTATS profiles using InfoSphere Optim Query Workload Tuner
  2. Capture SQL Statements using InfoSphere Optim Query Workload Tuner
  3. Monitor performance and tune for DB2 on zOs

Articles

  1. Quick Start guide on IOQWT
  2. Handling access plan changes using IOQWT
  3. Tuning SQL presented in three parts - Part 1, Part 2 and Part 3
  4. Query tuning with IOQWT. Not just for hardcore DBAs any more