Informix Error -927

Reasons / Common Causes

-927 fires when a single statement references more sites/servers than the limit allows — per the official guidance, through Version 4.1 the limit was 32 different site names in one statement, with later versions potentially allowing more.

1. A statement referencing more than the platform's site-name limit, per the official guidance — most likely in a generated or programmatically-assembled distributed query.
2. A query design that queries many sites directly in one statement, rather than staging data locally first.

Solutions / Resolution

1. Review the statement and check that only necessary sites are named, per the official guidance — remove any sites that aren't actually needed for this specific query.
2. Revise the operation to use fewer sites, per the official guidance, for example by selecting some data into a local, temporary table first, then working against that local staging data instead of querying every remote site directly in one statement.

Examples

Staging remote data locally to reduce the site count in later statements

SELECT * FROM site1@server1:orders INTO TEMP staged_orders;
-- repeat per site, then work against staged_orders locally instead of
-- referencing every site directly in a single combined statement

Diagnostic Checks

1. Count the distinct site/server names referenced in the failing statement against the platform's documented limit (32 through Version 4.1; check current documentation for later versions).

Related Errors / Related Topics

No closely related error codes are cross-referenced for -927 in this set yet.

Stage data from remote sites into a local temp table first, rather than referencing many sites directly in one statement.