Informix Error Messages and Error Codes From Error 29000 to 29003

SQLServerF1

Informix Error Code -29000 Application server error (server_error_number).
A generic application-server error occurred. Examine the original foreign SQLCODE. You can find it in either SQLERRD[1] or as part of SQLERRM. Look up the explanation for this SQLCODE in the documentation for the foreign server product. Apply the token(s), if any, that is returned in the SQLERRM field to the explanation.
Informix Error Code -29002 Supplied real-RDB-name does not match the real-RDB-name in sqlhosts.
A mismatch was detected between the user-supplied real-RDB-name and the real-RDB-name that was derived from the user-supplied alias-RDB-name using the sqlhosts file.
Check the spelling of the user-supplied real-RDB-name. Ensure that the user-supplied alias-RDB-name is the correct one.

If SNA network protocol is used to connect to the application server, check the real-RDB-name column (the “hostname” field) in the “sqlhosts” file for the alias-RDB-name entry, and check that it is spelled correctly.
If TCP/IP network protocol is used to connect to the application server, check the “RDB=real-RDB-name” option (in the “options” field) in the “sqlhosts” file for the alias-RDB-name entry, and check that it is spelled correctly.

Informix Error Code -29003 RDB real-RDB-name not found at the application server.
Although a communication conversation was allocated, the application server refused to connect because it has a real-RDB-name that is different from that to which the application would like to connect.
Examine the sqlhosts file on the Gateway computer. Identify the entry with the alias-RDB-name to which the application is referring.
If SNA network protocol is used to connect to the application server, ensure that the “hostname” field contains a correct value.
If TCP/IP network protocol is used to connect to the application server, ensure that the “RDB=real-RDB-name” option in the “options” field contains a correct value.

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.

Thanks,
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 *