Informix Error Messages and Error Codes From Error 179 to 197


Informix Error Code -179 ISAM error: No free disk space for sort.
While performing a sort, the database server did not find enough contiguous free disk space to create necessary temporary files. You might have insufficient disk space and need to make more disk space available before you run the program again. You might have made an error when you specified the names of temporary dbspaces in DBSPACETEMP or directory names in PSORT_DBTEMP. Check the spelling of your temporary space names as specified in DBSPACETEMP. If you specified multiple temporary dbspaces, check that you used colons (:) or commas (,) as delimiters.
Informix Error Code -181 ISAM error: No Optical Subsystem connection.
The Optical subsystem is not present. This message usually means that you requested an Optical operation on an database server that is being used without the Optical subsystem or INFORMIX-OnLine/Optical.

Informix Error Code -182 ISAM error: Duplicate optical BLOBSpace name.
A storage space for TEXT or BYTE data has been defined with the same name as an Optical family name.
Informix Error Code -190 ISAM error: Transaction table overflow.
No more slots are available in the transaction table. To see this table, run onstat with the -x option.
Informix Error Code -191 ISAM error: No such chunk.
The chunk that was specified to be dropped does not exist.

Informix Error Code -192 ISAM error: Can not drop first chunk.
The first chunk of a storage space is never a candidate to be dropped. Select a different chunk.
Informix Error Code -193 ISAM error: Chunk is busy.
Logical recovery cannot roll forward a chunk add because the chunk already exists. This error results when the chunk is dropped from a storage space, or the space is dropped, and the chunk is reused for another storage space without a level-0 backup performed first.
Informix Error Code -194 ISAM error: Chunk not empty.
A chunk is not empty and therefore cannot be dropped.
Informix Error Code -196 ISAM error: Operation not allowed in temporary dbspace.
An operation was executed on a temporary dbspace that required functionality that temporary dbspaces do not provide (most likely logging). Use a nontemporary dbspace for this operation.
Informix Error Code -197 ISAM error: Partition recently appended to; can’t open for write or logging.
If this internal error recurs, please note all circumstances and contact Informix Technical Support.


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 *