Oninit
Talk to an expert →

Informix Error -23198

-23198 GL-COLLATE information is missing from the system catalogs.

No locale information GL_COLLATE exists in the system catalog. The system catalog systables might be missing or corrupted. Drop the database and re-create it with the correct value for DB_LOCALE.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-23198 fires when no GL_COLLATE locale information exists in the systables system catalog — per the official guidance, the catalog might be missing or corrupted.

  1. A missing or corrupted systables system catalog, per the official guidance — the direct, only cause.
Solutions / Resolution
  1. Drop the database and re-create it with the correct DB_LOCALE value, per the official guidance.
Examples
N/A

No specific triggering statement is documented beyond a missing GL_COLLATE catalog entry.

Diagnostic Checks
  1. Check whether systables is missing or corrupted, and drop/re-create the database with the correct DB_LOCALE if so.
Related Errors / Related Topics
  • -23197 — "Database locale information mismatch." A related catalog-locale error, on GL_CTYPE/GL_COLLATE disagreeing with DB_LOCALE rather than being entirely absent.
  • -23199 — "GL_CTYPE information is missing from the system catalogs." The mirror- image error, for GL_CTYPE rather than GL_COLLATE.

GL_COLLATE locale information was missing from the system catalog — drop and re-create the database with the correct DB_LOCALE.