DB6: Move table data online

October 28, 2009 at 4:41 am

[] [] [] [] [] [] []

Symptom
You want to move table data online using the stored procedure ADMIN_MOVE_TABLE.
Other terms
online table move stored procedure, DB2 LUW
Reason and Prerequisites
You are using DB2 9.7 GA and you would like to move table data online.For DB2 9.7 GA, the stored procedure ADMIN_MOVE_TABLEmust notbe used.There is a known problem which will be corrected in DB2 [...]

DB6: Stored procedure for online table move

June 25, 2009 at 4:02 am

[] [] [] [] [] [] [] []

Symptom
You want to move tables online between tablespaces using the stored procedure ONLINE_TABLE_MOVE.
Other terms
online table move stored procedure
Reason and Prerequisites
For Linux and UNIX only: You are using DB2 Version 8.2.2 or higherFor Windows only: You are using DB2 Version 9.1 or higherDB2 registry variable DB2_SKIPDELETEDmustbe set to OFF.The SYSTOOLSPACE tablespace must be accessible for ‘PUBLIC’.
To [...]