Articles & Content


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

Topic: 2014 EMEA

Subtopic: DB2 for LUW

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.

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.