ADMIN_MOVE_TABLE : the DBA's New Swiss Army Knife

Session Number: 1902
Track: DB2 for LUW Lessons Learned (D)
Session Type: Podium Presentation
Primary Presenter: Philip Nelson [ScotDB Ltd.]
Time: Nov 15, 2011 (02:15 PM - 03:15 PM)
Room: Stella

Speaker Bio: Philip Nelson has work with the DB2 family of databases for over 20 years. His areas of expertise include data modelling and database design, performance tuning and exploiting DB2 with new technologies and open source software. He is an IBM Information Champion and also is the Executive Editor of the IDUG Solutions Journal. He is a regular speaker at IDUG, IBM IOD and other conferences worldwide.
Audience experience level: Beginner, Intermediate
Presentation Category: Implementing New DB2 Releases and Features
Presentation Platform: Select a Value
Audiences this presentation will apply to: Database Administrators, New Users
Technical areas this presentation will apply to: High Availability (DB2 for LUW), New Release (DB2 for LUW), Tools and Utilities, User Experiences
If Tools and Utilities was selected which products: ADMIN_MOVE_TABLE (DB2 core facility)
Objective 1: An understanding of the basic functionality and syntax of ADMIN_MOVE_TABLE including its strengths and weaknesses
Objective 2: Different modes of operating ADMIN_MOVE_TABLE : in particular comparing the "all in one step" and "multi-phase" approaches
Objective 3: How to use ADMIN_MOVE_TABLE_UTIL to control the operation of ADMIN_MOVE_TABLE.
Objective 4: Description of the advanced features of ADMIN_MOVE_TABLE available through use of the input parameters
Objective 5: A range of practical examples will be provided on exploiting the advanced features of ADMIN_MOVE_TABLE to carry out a range of admin tasks and table modifications

Abstract:  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.