Host CommentaryAs you might recall, Thiru Swamy was DB2's GOT TALENT 2011 2nd Place winner. Frankly, his presentation was very polished, fun, and informative. Even if you are not running SAP, Thiru offered advice and tips that can be used with any DB2 LUW database.
Nadir Doctor has previously presented at IDUG conferences. He's smart and very enthusiastic about DB2. I thought the SQL he shared for analyzing indexes and RUNSTATS was clever and helpful - especially the SQL that can help find redundant indexes. I hope to try it out myself within the next few days.
Join The DB2Night Show™ LinkedIn GroupThe DB2Night Show™ has a LinkedIn Group. The "closed" group is open to any LinkedIn member. Join to receive 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!
A message from today's show sponsor
During today's quick commercial break, DBI provided a very short demonstration of Brother-Panther® for DB2 LUW. We acknowledge that the SAP Cockpit is a pretty good tool for analyzing SAP performance "in the present", but SAP users agree that it lacks robust history. In today's demonstration, we showed how Brother-Panther can produce historical trend charts of key metrics, and then quickly zoom in on the SQL workload that was executing during a time frame of interest. Also, Brother-Panther makes it easy to compare performance between two different time windows. For a comprehensive list of Brother-Panther's industry leading features, visit our DB2 Tools Comparison.
Our #2 Job is giving you the documentation to prove it!
Get the Download Replay
To download a recorded replay of Episode #61, right click on the link below and choose "Save As..."
Episode 61, 28 October 2011, SAP Cockpit and SQL Tips.
Have an iLife, iDevice, iPod, iPad, or iPhone? Right click and download the M4V ( MP4 ) format!
Share a great show with your friends and followers:
REMEMBER to REGISTER for upcoming shows! www.DB2NightShow.com Our Season #3 show schedule is published through the end of 2011!