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.)

If you run out of log space or disk space, try one of the following procedures to reduce your log-space or disk-space requirements:

• 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 IBM Informix Administrator's Guide. That guide also contains detailed instructions about how to turn off logging. For information about backups, refer to your IBM Informix Backup and Restore Guide.