Informix Error -560: Synonym with tabid number not found in systables.

Reasons / Common Causes

-560 indicates catalog corruption: syssyntable has an entry pointing at a tabid that no longer has a corresponding row in systables (or an index on one of these two catalogs has become inconsistent with the data it indexes).

1. Corruption in systables or syssyntable, or an index on either, per the official guidance — the stated cause, with no lesser application-level explanation offered.
2. An interrupted or crashed DDL operation (dropping a synonym or its base table) that left the two catalogs out of sync with each other.
3. Disk-level corruption or an incomplete recovery affecting the dbspace holding the system catalog.

Solutions / Resolution

1. Run bcheck or secheck, per the official guidance, to diagnose the catalog inconsistency — which specific utility applies depends on the platform/version in use.
2. Be prepared to drop and re-create all synonyms, per the official guidance — this is stated as the expected remediation once the underlying catalog corruption is addressed.
3. Engage IBM Informix Technical Support if bcheck/secheck confirms catalog corruption beyond what a synonym drop-and-recreate resolves, since this reflects a system-catalog integrity problem rather than an application-level mistake.

Examples

Running the diagnostic utility

$ bcheck stores7
-- or, on platforms where it applies:
$ secheck stores7

Review the output for reported inconsistencies in systables/syssyntable or their indexes.

Diagnostic Checks

1. Run bcheck/secheck against the affected database, per the official guidance, as the first diagnostic step.
2. Inventory all synonyms in the database before any drop-and-recreate, so none are lost in the remediation:

   SELECT tabname FROM systables WHERE tabtype = 'S';
   

Related Errors / Related Topics

No closely related error codes are cross-referenced for -560 in this set yet.

A system-catalog corruption error — run bcheck/secheck first, and be prepared to drop and re-create every synonym in the database as the documented remediation.