Informix Error Messages and Error Codes From Error 1795 to 1801


Informix Error Code -1795 The number of chunks specified in shared memory, num_chunks, is too large.
The maximum allowable number with the current configuration is num_chunks. Specify larger chunk sizes, and reduce the number of chunks.
-1796 The database server detected a mismatch in the registry subkey data for MIRRORPATH. The data retrieved for MIRRORPATH was pathname.
The root dbspace has not been mirrored. To add mirroring, use onspaces or onmonitor.

Informix Error Code -1797 The root dbspace is not large enough for the specified configuration. The actual size is sizenum, and the required size is sizenum.
The root dbspace will not fit on the specified drive. Free the amount of space that is needed on the specified drive, or change the ROOTPATH configuration parameter to specify a different drive with more space available. Then restart the database server with the -iy parameters to initialize the root dbspace.
Warning: Starting the database server with the parameters -iy reinitializes the root dbspace and effectively destroys any existing data. You will no longer be able to access existing databases unless you subsequently perform a full-system restore. Do not reinitialize the root dbspace unless you are certain that you want to do so.

Informix Error Code -1800 Invalid transaction state.
You must commit or rollback the current transaction before you disconnect.
Informix Error Code -1801 Multiple-server transaction not supported.
You are attempting to span multiple connections within a single transaction. You can switch to a different connection while a transaction is active if you use the WITH CONCURRENT TRANSACTION clause when you establish the connection.
This error message can occur when you try to switch connections as follows:
If the current connection is to a Version 6.0 or later database server, you did not specify the WITH CONCURRENT TRANSACTION clause when you established the connection, and there is an active transaction in the current connection.
If the current connection is to a Version 5.0 database server, you did not specify the WITH CONCURRENT TRANSACTION clause when you established the connection, and a database is currently open on this connection.

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 *