Posted on 2/12/2010
In our 12th show, special guest Susan Visser, Publishing Program Manager, IBM, introduced us to "The Wild Wonderful World of DB2 Information Resources ". I had no idea that there were so many free and inexpensive resources available for quality DB2 information. Watch the replay of this episode to learn about the best blogs, best selling DB2 books, and the best websites for DB2 Information...
To download a recorded replay of Episode #12, right click on the link below and choose "Save As... "
Episode 12, 2010 Feb 12, The Wild Wonderful World of DB2 Information Resources with Susan Visser (58MB)During this episode, Susan referred to her blog and hyperlinks therein on a number of occasions. You can find Susan's blog here:https://www.ibm.com/developerworks/mydeveloperworks/blogs/SusanVisser/?lang=en_us Also during this episode, we announced a new LinkedIn Group for The DB2Night Show™. The group is an open group. Join to received LinkedIn group updates including future shows and replay information, and, if you like, start some discussions about the show! Join The DB2Night Show LinkedIn Group! Thanks for watching! A Shameless Marketing Moment During this episode, DBI's short two minute sponsorship commercial included a brief live demonstration of DBI's performance analysis, tuning, and trending tools for DB2 LUW. Here's what we did: - Click 1: Database Triage - identify the database having the worst performance problems
- Click 2: Statement Analysis showed one SQL statement using over 80% of all database CPU time
- Click 3: We Explained the SQL statement and determined than an index was needed
- Click 4: We passed the high CPU cost statement to the IBM Design Advisor and received validation - a second opinion if you will - that the index we thought was needed was indeed needed, and that the proposed index would provide a tremendous CPU cost reduction.
THAT'S IT - JUST FOUR MOUSE CLICKS IN under 90 SECONDS to identify, isolate, and resolve a performance problem! We could have done it in just three clicks but didn't want to show off! :icon_biggrin: While you're here and waiting for your download to complete, why not spend a minute checking out DBI's performance management tools for IBM DB2 LUW? Visit our DB2 Performance Solutions page to get started! A typical DBI customer reduces CPU utilization by 30-90% and improves response times within just a few hours of DBI tools installation! DBI helps worldwide customers achieve remarkable breakthrough results overnight with a ripple effect of measurable bottom line benefits and rapid ROI. Cheers,
Your host,
Scott Hayes |