Informix Error -26600: Exceeded limit on maximum number of concurrent open databases.
Cause and resolution
Exceeded limit on maximum number of concurrent open databases.
The query is requesting too many concurrent open databases. The query is likely to have nested routine calls or cascading trigger actions. Reduce the nested routine calls or the cascading trigger actions and retry the query.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-26600 fires when a query needs more concurrently open databases than the server allows — per the official guidance.
- Nested routine calls opening additional databases, per the official guidance — a likely cause.
- Cascading trigger actions opening additional databases, per the official guidance — a likely cause.
Solutions / Resolution
- Reduce the nested routine calls or cascading trigger actions and retry the query, per the official guidance.
Examples
N/A
No specific triggering statement is documented beyond excessive concurrent open databases from nested calls/triggers.
Diagnostic Checks
- Check the query for deep nested routine calls or cascading triggers spanning multiple databases, and reduce their depth/breadth.
Related Errors / Related Topics
No closely related error codes are cross-referenced for -26600 in this set yet.
Too many databases were concurrently open, likely from nested routine calls or cascading triggers — reduce their depth and retry.