Informix Error -907: Cannot create socket on current database server.
Cause and resolution
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
sqlexecdnot 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.