The DB2Night Show #15: DB2 9.7 Online Table Moves with Ergin Babani, IBM


Posted by Scott on April 2, 2010, 4:46 pm
in DB2 LUW ( The DB2Night Show)

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...
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 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. icon_wink


Contact DBI and find out how our DB2 LUW Performance Solutions can truly help you optimize performance and lower IT costs.

Post from : http://www.dbisoftware.com/blog/db2nightshow.php
Printed from : http://www.dbisoftware.com/blog/db2nightshow.php?id=191