Articles & Content


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

Topic: DB2 for LUW

Subtopic: 2011

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.