Articles & Content

Archives

ADMIN_MOVE_TABLE : the DBA's New Swiss Army Knife (D07)

Topic: 2011 EMEA

Subtopic: DB2 for LUW



DB2 9.7 provided a new system stored procedure called ADMIN_MOVE_TABLE. In it's simplest form it allows simply online movement of a table from one place to another. But it can do so much more than this. This presentation will start with the simplest use case. It will then move on to explore the control mechanisms available through ADMIN_MOVE_TABLE_UTIL. It will then show how to use the procedure for a range of more complex transformations, seeking to show how the ability to exploit this tool should be an essential part of the DBA's skillset.



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.