Set explain on fails

Set explain on fails

Set explain on fails (sqlcode: 586 (I think) ISAM: 1) (Could not open sqexplain.out). We have plenty of disk space and file permissions. It even failed as “root” in /tmp with permissions of rwxrwxrwx. However, as user “informix” in the /tmp directory, but not directories with rwxrwxr-x, it succeeded. This only happens on three of four databases (with very similar schemas) on one machine.

You are probably experiencing a 581 error (Error in loading message file) rather that a 586 error (Cursor already open).

Once you have the correct error message number, you will find that the finderr command is very useful. On the operating system command line, type:

finderr 581
You will get:
Error loading message file
The SET EXPLAIN statement could not be completed because the database server was unable to find the file of message templates it uses when preparing explanatory output. Consult with the person who installed the Informix software.

This error message will definitely point you in the right direction, but it doesn’t give you the entire answer. If you are getting this message, your Informix software was installed incorrectly. However, since you are getting this message, the person who installed the software is probably not going to know what he did wrong in the first place.

The trick here lies in reading the installation manuals and noting the part about the order of Informix software installation. The acronym here to remember is TEN: Tools, Engine, Networking. This is the order in which you must install your Informix components for everything to work properly. So install your tools (4gl, esql, etc.) first, then your database engine, then your Informix networking software (if any).

This is actually a fairly frequent problem because even if the initial product installation is done correctly, you may later receive a tools update and simply load that without remembering that you also need to reload the engine and networking products. Fortunately, this is a relatively simple problem to solve. You should simply need to take your engine down, and then re-install the products in the correct order.

Share the Post:
Heading photo, Metadata.

What is Metadata?

What is metadata? Well, It’s an odd concept to wrap your head around. Metadata is essentially the secondary layer of data that tracks details about the “regular” data. The regular

XDR solutions

The Benefits of Using XDR Solutions

Cybercriminals constantly adapt their strategies, developing newer, more powerful, and intelligent ways to attack your network. Since security professionals must innovate as well, more conventional endpoint detection solutions have evolved

AI is revolutionizing fraud detection

How AI is Revolutionizing Fraud Detection

Artificial intelligence – commonly known as AI – means a form of technology with multiple uses. As a result, it has become extremely valuable to a number of businesses across

AI innovation

Companies Leading AI Innovation in 2023

Artificial intelligence (AI) has been transforming industries and revolutionizing business operations. AI’s potential to enhance efficiency and productivity has become crucial to many businesses. As we move into 2023, several