Company's database server located at Toronto and users from US, India and from other locations are accessing this database. Tablespace TBS1 in a database is full and DBA cannot add any more disk to the containers, DBA decided to move to a different tablespaces with new container storage without making any outages.
To move to a different tablespaces DBA has to offline the database, that will cause the loss of million dollars to the company.
Starting from DB2 9.7 you can move tables by using an online or offline move using the ADMIN_MOVE_TABLE procedure. The ADMIN_MOVE_TABLE stored procedure moves the data in an active table into a new table object with the same name, while the data remains online and available for access. Use an online table move instead of an offline table move if you value availability more than cost, space, move performance, and transaction overhead.
You can move a table online by calling the stored procedure once or multiple times, one call for each operation performed by the procedure. Using multiple calls provides you with additional options, such as cancelling the move or controlling when the target table is taken offline to be updated.
Ensure there is sufficient disk space to accommodate the copies of the table and index, the staging table, and the additional log entries.