At work I upgraded our DB2 installs to 9.7 last year and 1 of the new features in 9.7 that looked interesting was the ADMIN_MOVE_TABLE procedure.
This procedure claimed to move tables online. Although it does do this, it has some limitations that you need to be aware of...
Referential Constraints
The major one is that it doesn't handle referential constraints. So you need to drop them on the table you want to move and also any FK constraints on other tables that link to the PK of the table you want move. Then when the move is finished you would need to manually create them again. This limitation can be an issue if you rely on the constraints to CASCADE a delete or update.
Comments
I also found that the comments on a table weren't copied to the new table, including column comments.
Privileges
The user that you use to run the procedure needs to have SECADM rights otherwise it won't copy the GRANTS on the table. I know this isn't a limitation but i thought it was worth mentioning.
No comments:
Post a Comment