Informix Error Messages and Error Codes From Error 23107 to 23109


Informix Error Code -23107 DBLANG and CLIENT_LOCALE environment variables are incompatible.
DBLANG is the environment variable that points to the location where the message files are stored. Usually, the value of DBLANG corresponds with that of CLIENT_LOCALE. The value of DBLANG could be en_US.8859-1 or a value set according to X/Open standards for locale definitions. The locale is a set of files that defines the characteristics of a particular language (for example, French or Japanese), a particular territory (for example, France or Japan) and a particular code set (for example, MS Windows Code Page 1251 or ISO 8859-1). An example of a locale name for the French language in Canada that is encoded using ISO 8859-1 would be fr_CA.8859-1, and a locale name for the Japanese language that is encoded using EUC (Extended Unix Code) would be ja_JP.ujis.
Reexamine the value of the environment variables, DBLANG and CLIENT_LOCALE.

Informix Error Code -23108 An error occurred during locale structure creation.
The locale initialization failed. The program cannot allocate enough memory for the internal locale table. The memory might be exhausted due to the execution of too many processes. Rerun the program after you free some memory.

Informix Error Code -23109 Invalid locale specification.
A locale, with which all locale-sensitive processing occurs, is established on both the client and database server side. This processing locale is set with information from environment variables and from data that is stored in the database. An internal function could not compose the long form of the NLS locale in its internal array. Not all the categories (LC_COLLATE, LC_CTYPE, LC_MONETARY, LC_NUMERIC, LC_TIME) could be composed. Check the value of the environment variables CLIENT_LOCALE and DB_LOCALE. Also check the value of INFORMIXDIR.

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 *