Informix Error Messages and Error Codes From Error 211 to 214


Informix Error Code -211 Cannot read system catalog catalog-table.
The database server refers to the tables of the system catalog while it processes most statements. When it cannot read one of these important tables, a serious error results. Check the accompanying ISAM error code for more information. The effect of the error depends on the statement that is being executed and the particular table, as follows:
CREATE TABLE statement, systabauth not read; the table is created, but PUBLIC is not granted authorization as it normally is.
DROP TABLE statement, systables not read; no action taken.
DROP TABLE statement, sysviews not read; the table is dropped but any views that depended on the table were not automatically dropped.
DROP VIEW statement, sysviews not read; no action taken.
DROP INDEX statement, sysindexes or systables not read; no action taken.
DROP SYNONYM statement, systables or syssynonyms not read; no action taken.
DROP DATABASE statement, systables not read; no action taken.
START DATABASE statement, systables not read; no action taken.
DATABASE statement, systables or sysusers not read; the database was not selected (no current database; for subsequent operations, see error -349).
Other statements may be partially complete before the error is detected. Roll back the current transaction and then investigate the cause of the error. Use the bcheck or secheck utility (tbcheck with INFORMIX-OnLine or oncheck with INFORMIX-OnLine Dynamic Server) to check and repair indexes. If necessary, restore the database from backup and logical-log tapes.

Informix Error Code -212 Cannot add index.
This statement attempts to add an index, either explicitly with CREATE INDEX or implicitly as part of processing a SELECT on multiple unindexed tables. In any case, some error prevents the index from being created. For more information, check the accompanying ISAM error code. Insufficient disk space is a common cause of this problem.

Informix Error Code -213 Statement interrupted by user.
The database server received an interrupt signal from the user, probably because the user pressed the interrupt key (usually Delete or Control-C). The statement ended early. A program should roll back the current transaction and terminate gracefully. If the statement could modify a table, an interactive user should execute the ROLLBACK WORK statement to remove any partial modifications.
Informix Error Code -214 Cannot remove file for table table-name.
The database server cannot completely remove the table. Check the accompanying ISAM error code for more information. Problems with operating-system file permissions, read-only files, or hardware might cause this error.

Above are list of Informix Error Messages and Errors Codes or Status Codes or Exit Codes along with Error and Warning messages received while performing certain operation against Informix applications or related products.

What are Informix Error Messages?
All Informix messages returned by the Informix server are assigned an error code.

In general, each Informix error contains the following information:
• The Informix Error Code or Informix Error status
• The message text. This text is usually returned with the Error code. Some messages employ word substitution, where the word substituted represents the system-replacement of a term more specific to the occurrence.
• An explanation of how the error may have occurred.

Hope this was helpful.

SQLServerF1 Team
Information about Informix Error Codes or Status Codes or Exit Codes and Error Messages on Windows, Linux Operating Systems.


Leave a Reply

Your email address will not be published. Required fields are marked *