Oninit
Talk to an expert →

Informix Error -27006

-27006 Network driver cannot establish listen endpoint.

You specified stream pipe (ipcstr) as the network-communication type for this database server. The database server is not able to create the stream pipe. The most common cause of this error is that another database server on your network is already using the service name for this database server.

Check that the servicename value in the $INFORMIXDIR/etc/sqlhosts file or in the SQLHOSTS registry information is unique across all database servers on your network. If the servicename is unique, check the accompanying ISAM code for additional error information.

If a previously created stream pipe with the same name is not released by an aborted online server, you need to manually remove the stream pipe files /INFORMIXTMP/<servicename>.str and /INFORMIXTMP/<servicename>.exp. </servicename></servicename>

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-27006 fires when a stream-pipe (ipcstr) database server can't create its stream pipe — per the official guidance, the most common cause is another server on the network already using the same service name.

  1. Another database server on the network already using the same servicename, per the official guidance — the most common cause.
  2. A previously-created stream pipe left behind by an aborted online server, per the official guidance — a secondary cause.
Solutions / Resolution
  1. Check that servicename in $INFORMIXDIR/etc/sqlhosts (or the SQLHOSTS registry entry) is unique across the network, per the official guidance.
  2. If unique, check the accompanying ISAM code for further detail, per the official guidance.
  3. Manually remove leftover stream-pipe files /INFORMIXTMP/<servicename>.str and /INFORMIXTMP/<servicename>.exp, per the official guidance, if an aborted server left them behind.
Examples
N/A

No specific triggering statement is documented beyond a stream-pipe-creation failure.

Diagnostic Checks
  1. Check servicename uniqueness across the network, the accompanying ISAM code, and for leftover /INFORMIXTMP/<servicename>.str/.exp files from an aborted server.
Related Errors / Related Topics
  • -25572 — "Network driver cannot bind a name to the port." A related network-driver binding failure, for TCP/IP ports rather than IPC stream pipes.

The network driver couldn't establish a stream-pipe listen endpoint, usually from a duplicate servicename or a leftover pipe file — check both.