Try OpenEdge Now
skip to main content
Database Essentials
Database Administration : Periodic monitoring tasks : Moving tables
 

Moving tables

The purpose of the table move utility, PROUTIL TABLEMOVE, is to move a table from one storage area to another. This allows you to balance your I/O or group similar tables. You can run this utility while users are accessing the database, but users will be locked out of the table being moved for the duration of the move. The table move utility requires a significant amount of logging space which affects the primary recovery and after-image areas. In the primary recovery area, logging of the move process uses three to four times the amount of space occupied by the table itself. If you did not plan accordingly, you run the risk of crashing the database because of a lack of space in the primary recovery area. You should test your table move on a copy of your database before using it against production data.