Informix Error Messages and Error Codes From Error 12085 to 12088


Informix Error Code -12085 Smartblobs: Restore: -1 chunk # found ===> SB_ARC_END_DESC record not found for this chunk.
The archive tape was corrupted either by a user error or a database server malfunction. Ensure that the archive file was not corrupted through user error. If the archive file is intact, the database server malfunctioned. You can either try to create another archive of the same sbspace, or you can remove the sbspace from the list of spaces to be archived and try to archive the remaining spaces.

Informix Error Code -12086 Smartblobs: open: invalid open flags detected at smart-large-object open time.
A programmer has entered conflicting smart-large-object open flags. For instance, LO_LOG and LO_NOLOG cannot be set at the same time. Check open flag settings to ensure that conflicting flags are not being set. In addition, ensure that the smart-large-object open-flag field is initialized.

Informix Error Code -12087 Smartblobs: alter: attempt to change physical characteristics of a smart large object in sb_alter.
The DBA attempted to perform an alter operation on a smartblob column that requires physical reorganization or relocation of the smart large objects. Do not attempt to reorganize smart large objects physically. As an alternative to physical reorganization, try using the LOCopy function to copy smart large objects to a new location with different physical attributes.
Informix Error Code -12088 Smartblobs: create: number of estimated bytes <-1.
The application programmer has specified an invalid value for the estimated number of bytes in a smart large object. If the number of bytes in a smart large object is unknown, set the estimated number of bytes field to -1 or call ifx_lo_def_create_spec or the equivalent mi function and then leave this field alone.

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 *