Online table move

Online Table Move (OTM) is the process of moving a table without a service disruption. Have you ever had the need to change something such as tablespace extent size? How about the need to reclaim tablespace filesystem storage when you're unable to use REDUCE MAX? If you can take the source table(s) out of service for some varying length of time, there are several possible solutions. But, what if the table(s) cannot be offline for any amount of time?

The stored procedure ADMIN_MOVE_TABLE can be used to move data in an active table to a new object with the same name, keeping the data online and available. A typical ADMIN_MOVE_TABLE statement looks like the following:

CALL SYSPROC.ADMIN_MOVE_TABLE 
 ( 
   [TableSchema], [SourceTable], [TargetDataTS], 
   [TargetIndexTS], [TargetLongTS], [MDC_Columns], 
   [PartitionKeys], [DataPartitions], [ColumnDefs], 
 ...