Informix Error -27000: Cannot support multiple connections over shared memory.
Cause and resolution
Cannot support multiple connections over shared memory.
An application cannot use the CONNECT statement to make more than one connection that uses shared-memory communication (IPC).
Ensure that the application makes only one shared-memory connection at a time. If the application must use concurrent connections, the database server administrator might need to change the connection type (as specified in the nettype field of the sqlhosts file) from a shared -memory connection to a network connection.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-27000 fires when an application tries to make more than one shared-memory (IPC)
connection via CONNECT — per the official guidance.
- The application attempted a second
CONNECTusing shared-memory communication, per the official guidance — the direct, only cause; only one shared-memory connection is allowed per application.
Solutions / Resolution
- Ensure the application makes only one shared-memory connection at a time, per the official guidance.
- If concurrent connections are required, change the connection type in the
sqlhostsfile'snettypefield from shared-memory to a network connection, per the official guidance — a database server administrator may need to make this change.
Examples
N/A
No specific triggering statement is documented beyond a second concurrent shared-memory
CONNECT.
Diagnostic Checks
- Check how many shared-memory connections the application makes concurrently, and
reduce to one, or switch to a network
nettypeinsqlhostsif concurrency is required.
Related Errors / Related Topics
No closely related error codes are cross-referenced for -27000 in this set yet.
An application tried to open more than one shared-memory connection — allow only one at a
time, or switch to a network connection type in sqlhosts.