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 Toronto
We 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.