ALTER FRAGMENT and Transaction Logging
If your database supports transaction logging, ALTER FRAGMENT is executed within a single transaction. If the fragmentation strategy uses large numbers of records, you might run out of log space or disk space. (To alter a fragmentation strategy, the database server requires extra disk space that it later frees.)
- Turn off logging and turn it back on again at the end of the operation. This procedure indirectly requires a backup of the root dbspace.
- Split the operations into multiple ALTER FRAGMENT statements, moving a smaller portion of records each time.
For information about log-space requirements and disk-space requirements, see your HCL OneDB™ Administrator's Guide. That guide also contains detailed instructions about how to turn off logging. For information about backups, refer to your HCL OneDB Backup and Restore Guide.