Beck Tang, Zahidul Khan, Phil King – IBM
Abstract
Tired of scheduling downtime for table reorganizations? Need to move a large table to different storage but can’t afford an outage? Want to convert tables to columnar storage without impacting users? ADMIN_MOVE_TABLE is your answer.
This session shows you how to perform complex database operations—table moves, compression updates, storage changes, and more—while your applications stay online and users keep working. No more weekend maintenance windows for routine database tasks.
You’ll discover how to:
– Move tables between tablespaces without downtime
– Change table structures (add columns, modify data types) while applications run
– Optimize compression to reclaim storage space—online
– Convert row-organized tables to columnar (BLU) for analytics workloads
– Handle both simple and complex scenarios with confidence
– Monitor operations and troubleshoot issues when they arise
– Apply best practices learned from real production environments
Whether you’re new to ADMIN_MOVE_TABLE or have used it before, this session provides practical guidance you can use immediately. We’ll cover common use cases, share lessons learned from 25 years of production experience, and show you how to avoid common pitfalls.
Perfect for DBAs who want to reduce downtime, improve operational efficiency, and make database maintenance less disruptive to the business.