Informix Error -27004: Illegal sqlhosts file option/parameter, parameter, for dbservername, servername.

Cause and resolution

Illegal sqlhosts file option/parameter, parameter, for dbservername, servername.

You specified an invalid option or parameter in your sqlhosts file. Check the option ID and parameter associated with servername in the sqlhosts file.

Linux,UNIX: If you use either the IPC stream pipe (onipcstr) protocol or the IPC shared memory (onipcshm) protocol, ensure that the communications file directory (cfd option) is shorter than or equal to 70 bytes. If the directory is a relative path, the length includes the $INFORMIXDIR directory.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-27004 fires when sqlhosts has an invalid option or parameter for the named database server — per the official guidance.

An invalid option/parameter in the sqlhosts entry for the named server, per the official guidance — the direct, only cause.
On Linux/UNIX with the IPC stream pipe (onipcstr) or IPC shared memory (onipcshm) protocol: a communications file directory (cfd option) longer than 70 bytes, per the official guidance — a specific named case.

Solutions / Resolution

Check the option ID and parameter for the named server in sqlhosts, per the official guidance.
On Linux/UNIX with onipcstr/onipcshm, keep the cfd directory at 70 bytes or fewer (including $INFORMIXDIR if relative), per the official guidance.

Examples

N/A

No specific triggering statement is documented beyond an invalid sqlhosts option.

Diagnostic Checks

Check the sqlhosts entry's option/parameter for the named server, and, on onipcstr/onipcshm, check the cfd directory's length.

Related Errors / Related Topics

No closely related error codes are cross-referenced for -27004 in this set yet.

An sqlhosts option/parameter was invalid for the named server — check it, and on onipcstr/onipcshm, check the cfd directory length (≤70 bytes).