Informix Error -792
-792 Cannot update the sysfragments system catalog table for an interval fragment.
An error occurred while updating the sysfragments system catalog table for the newly created interval fragment. Insufficient disk space is a common cause of this error.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-792 fires when the server can't update the sysfragments system catalog after creating a new
interval fragment — per the official guidance, insufficient disk space is the common cause.
- Insufficient disk space in the dbspace holding the system catalog, per the official guidance — the specifically named, common cause.
- An underlying catalog-write failure for other reasons, in the same general category as other catalog-update errors elsewhere in this range.
Solutions / Resolution
- Check disk space in the dbspace holding the system catalog, per the official
guidance — the first, most likely check:
onstat -d - Free space or add capacity if the catalog's dbspace is confirmed low, then retry the operation that triggered automatic interval fragment creation.
- If space isn't the issue, treat this similarly to other catalog-update failures in this reference (checking for concurrent activity, catalog consistency) before escalating.
Examples
Checking catalog dbspace free space
$ onstat -d
-- review free-page counts for the dbspace holding the system catalog
Diagnostic Checks
- Check disk space in the system catalog's dbspace first, per the official guidance.
- Retry the triggering operation once space is confirmed adequate.
Related Errors / Related Topics
- -790 — "Cannot create interval fragment." A related interval-fragmentation error, at the fragment-creation step itself rather than the subsequent catalog update.
Check disk space in the system catalog's dbspace first — per the official guidance, that's the common cause.