ADMIN_MOVE_TABLE(): Why would a DBA move a table? (Waiter As A Second Job?)

Short Abstract:

This user session is all about experience with a great tool for the DBA, whose database must be online all the time. Using it, one can achieve database version's architecture limits relief or improve performance instead of using regular tools.

 

Abstract:

I heard about admin_move_table() procedure several years ago at an Idug presentation, announcing DB2 9.7 for LUW. I first seemed to me a sidekick of some enthusiast, working in an IBM lab afternoon after everybody else left. Some time later i understood clearly that I was wrong, it resolved to be a crucial tool that has helped me and my fellow DBAs to achieve a list of  goals, dealing with advances in physical data layout, performance and most of all, availability. It is a great tool that provides exceptional usability, it is a Swiss army knife for every LUW administrator.

In this session, i will explain my experience with the procedure, starting with the basics, then topics of use, strengths and shortcomings and some hints. I will provide my view on its evolution from user procedure to more and more system integrated tool.