The
tablemove command runs using a single transaction, so that in the event of failure it is capable of an undo.
Since
tablemove is a transaction based operation, all adjustments for general performance recommendation are applicable.
Listed below is a summary of them:
- Start the database in multi-user mode, even when only the tablemove process is running
- Start APW, BIW to speed up the writes to the database files.
- Tune the BI block size and BI cluster size.
- Use -B, -bibufs, -spin, etc.
- Turn off After-Imaging
- Start the database with no-integrity, provided a valid backup of the database is taken beforehand.
IMPORTANT INFORMATION:
WHEN RUNNING DATABASE WITH THE -i PARAMETER, IF THE LOAD FAILS, THEN YOU MUST GO TO BACKUP!
For further information refer to Articles:
