DB2 9.7 introduces enhancements that allow you to make changes to the database objects while keeping these objects fully accessible to the database users during the modification. These enhancements allow database administrators to make vital changes to the database schema on the fly without any disruption to users.
This article includes examples that demonstrate how to use the ALTER TABLE command to rename columns and change column data types. Other examples demonstrate how to use the ADMIN_MOVE_TABLE routine to move and modify tables while keeping them accessible.