Sorry, this item is currently unavailable.

DB2 SQL Tuning Tips for Z/Os Developers

ISBN: 9780133038460 | 0133038467
Edition: 1st
Format: Paperback
Publisher: IBM Press
Pub. Date: 10/15/2012

Why Rent from Knetbooks?

Because Knetbooks knows college students. Our rental program is designed to save you time and money. Whether you need a textbook for a semester, quarter or even a summer session, we have an option for you. Simply select a rental period, enter your information and your book will be on its way!

Top 5 reasons to order all your textbooks from Knetbooks:

  • We have the lowest prices on thousands of popular textbooks
  • Free shipping both ways on ALL orders
  • Most orders ship within 48 hours
  • Need your book longer than expected? Extending your rental is simple
  • Our customer support team is always here to help
This well-organized, easy-to-understand reference brings together 102 SQL-related skills and techniques that any developer can use to build DB2 applications that deliver consistently superior performance. Legendary DB2 tuning expert Tony Andrews ("Tony the Tuner") draws on more than 23 years of DB2-related experience, empowering developers to take performance into their own hands - whether they're writing new software or tuning existing systems. Andrews reveals the hidden truth about why DB2 queries, programs, and applications often perform poorly, and shows developers exactly how to clear the bottlenecks and resolve the problems. He fully reflects the latest DB2 SQL programming best practices up to and including DB2 V9 and DB2 V10 on z/OS: techniques that are taught in no other book, and are rarely covered in typical DB2 training courses. Drawing on his extensive consulting experience and highly-praised live training courses, he also presents an invaluable 10-step methodology for tuning virtually any DB2 query. Coverage includes: * Systematically identifying and fixing poorly coded programs or improperly coded SQL statements * Understanding and taking advantage of Runstat options * Adding or altering indexes * Understanding and leveraging the latest SQL standards and guidelines * Effectively utilizing Existence Checking, and much more

Please wait while this item is added to your cart...