Informix Error Messages and Error Codes From Error 124 to 129

SQLServerF1

Informix Error Code -124 ISAM error: no begin work yet.
The ISAM processor has been asked to mark the end of a transaction, but no transaction has been started. For C-ISAM programs, review the program logic to make sure that it calls isbegin before it calls iscommit or isrollback. For SQL products, make sure that you execute BEGIN WORK before COMMIT WORK or ROLLBACK WORK.
Informix Error Code -125 ISAM error: can’t use nfs.
The ISAM processor has been asked to open a file that is located on a disk attached to another computer and that is accessed using the Network File System (NFS). This action is not supported. Database files must be on disks that are physically attached to the computer on which the ISAM processor is running. To use a database on a different computer, you must install the INFORMIX-STAR or INFORMIX-NET networking software. Then an application on this computer can communicate with a database server that is running on the computer to which the disks are attached.

Informix Error Code -126 ISAM error: bad row id.
The ISAM processor was asked to retrieve a row by its physical location but could not find a row at that location. For C-ISAM programs, if you are using access by record number, review the number stored in isrecnum; it is invalid. Otherwise, the current index may be damaged; run the bcheck or secheck utility. For SQL products, the index has been damaged; run the bcheck or secheck utility to check and repair it if you are using the INFORMIX-SE database server. Run tbcheck if you are using the INFORMIX-OnLine database server, or run oncheck if you are using INFORMIX-OnLine Dynamic Server or Informix Dynamic Server.
Informix Error Code -127 ISAM error: no primary key.
The ISAM processor was called for a function that requires a unique primary-key index, but no such index exists for this file. For C-ISAM programs, review the design of the data file; it was created with a zero-part primary index (that is, for retrieval by record-number sequence). If that is not the case, the index might be damaged; run the bcheck or secheck utility. If the error recurs, please note all circumstances and contact Informix Technical Support.

Informix Error Code -128 ISAM error: no logging.
The ISAM processor was called for a function that requires a transaction log, but none exists for this file. For C-ISAM programs, review the creation of the data file. Before the program uses functions such as isbegin, it must set up a log using islogopen. For SQL products, this database does not support transaction logging. If you are using the database server, have the database server administrator enable logging for this database. Otherwise, use the START DATABASE statement to begin transaction logging. In all cases, start logging only immediately after the database has been fully backed up.
Informix Error Code -129 ISAM error: too many users.
This implementation of ISAM uses shared memory, and it has reached the maximum number of concurrent users for which the shared memory was configured. You might need to increase the value of the USERTHREADS and TRANSACTIONS configuration parameters in the ONCONFIG file. If the problem recurs, contact the system administrator or the person who installed the product.
The word users can be misleading; the limit is on the number of concurrent application programs using the database server. It is possible for one user to start multiple applications at the same time. For example, when a user starts the INFORMIX-4GL Programmer’s Environment, it opens a session with the database server. When that user issues a command to compile a 4GL program, the 4GL compiler starts and also opens a session with the database server. During a compile, this user has two sessions running.

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 *