Posted on 4/2/2010
In our 15th show, we talked about the new Online Table Move capability in DB2 9.7. Our special guest was Ergin Babani, DB2 LUW Continuing Engineering, from the IBM Toronto Lab. Despite recovering from a cold and having a sore throat, Ergin did a fantastic job for us on covering the options and features of this new capability, along with some insights, tips, and best practices. Of particular note, we hit a new record for studio audience questions - there were a lot of really good questions that you'll want to hear the answers to...
To download a recorded replay of Episode #15, right click on the link below and choose "Save As... "
Episode 15, 2010 Apr 2, DB2 9.7 Online Table Moves with guest Ergin Babani, IBM TorontoWe don't usually do this, but Ergin's slide deck contains some very good examples of how to use ADMIN_MOVE_TABLE. In fact, after the show, he sent us an updated slide deck that includes an example of how to change column data types with ADMIN_MOVE_TABLE. We invite you to access a PDF copy of the slide deck: RIGHT CLICK HERE At a future time, we will attempt to update information about this show with more answers to questions that we didn't have time to get to. Please check back. The DB2Night Show™ now has a LinkedIn Group. The group is an open group. 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! Thanks for watching! Our Shameless Marketing Moment How can you verify that a change you made improved performance? In this episode, DBI demonstrated graphing the Average Elapsed Time and CPU time of an SQL Statement over a two month period. You'll see how the performance of the statement improved and also the details of the change that caused the improvement. Make changes with out fear. DBI tracks changes automatically (including before and after values) and visually shows you the performance consequences of changes. Use our performance trend charts on your next performance review to earn high praise from management. :icon_wink: Contact DBI and find out how our DB2 LUW Performance Solutions can truly help you optimize performance and lower IT costs. |