Informix Error -907

-907 Cannot create socket on current database server.

Informix STAR or IBM Informix NET is trying to access another computer system but is unable to create a connection. Contact your system administrator, and ask for a check that TCP/IP is correctly installed and functioning.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-907 fires when Informix STAR or IBM Informix NET can't create a network connection to another computer system — per the official guidance, checking TCP/IP's installation and function on the current system is the documented first step.

TCP/IP not correctly installed or not functioning on the current database server, per the official guidance — the direct, named cause.
A local resource limit (available sockets, file descriptors) preventing socket creation, a plausible OS-level contributor alongside a TCP/IP configuration problem.

Solutions / Resolution

Contact your system administrator, per the official guidance, and ask for a check that TCP/IP is correctly installed and functioning on the current system.
Check basic TCP/IP functionality as a first diagnostic step:
```
ping localhost
netstat -an | head -20
```

Examples

Basic TCP/IP sanity check

$ ping localhost
$ netstat -an | grep LISTEN

Diagnostic Checks

Check TCP/IP's basic function on the current system, per the official guidance's emphasis on the current server rather than the remote target.

Related Errors / Related Topics

-908 — "Attempt to connect to database server (servername) failed." A related cross-server connectivity error, about the remote server/network rather than local socket creation.
-903 — "Licensed Informix SQL server not accessible." A related networking error, about the remote host's sqlexecd not running rather than a local socket-creation failure.

Unlike most of the connectivity errors in this range, this one points at the current system's TCP/IP — check that first.