Informix Error -26509: Query contains a table in remote database
Cause and resolution
Query contains a table in remote database
This query was not accelerated because it contains a table that does not reside in the database to which the user is connected.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-26509 fires when a query isn't accelerated because it references a table outside the connected database — per the official guidance.
- The query contains a table not in the database the user is connected to, per the official guidance — the direct, only cause; not eligible for offloading.
Solutions / Resolution
- No action needed to "fix" this — per the official guidance, such a query runs on the database server instead.
Examples
N/A
No specific triggering statement is documented beyond a query referencing a remote- database table.
Diagnostic Checks
- This is an informational offload-diagnostic, not an error to fix.
Related Errors / Related Topics
No closely related error codes are cross-referenced for -26509 in this set yet.
A query wasn't accelerated because it references a table in a remote database — such queries run on the database server instead.