Oninit
Talk to an expert →

Informix Error -27009: Connection to HDR secondary not allowed using group name

Cause and resolution

Connection to HDR secondary not allowed using group name

Your INFORMIXSERVER setting specifies a group entry for an HDR pair. HDR primary server is currently not available, and HDR secondary server is still in secondary mode. To connect to HDR secondary server in read-only mode, set INFORMIXSERVER to the explicit DBSERVERNAME of the secondary server. To be able to process transactions, either bring up your HDR primary server, or convert your HDR seconadry server to standard mode.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-27009 fires when INFORMIXSERVER specifies an HDR group entry, the primary is unavailable, and the secondary is still in secondary mode — per the official guidance, a group-name connection can't reach an HDR secondary this way.

  1. INFORMIXSERVER set to an HDR group name while the primary is down and the secondary is still in secondary (not standard) mode, per the official guidance — the direct, only cause.
Solutions / Resolution
  1. Set INFORMIXSERVER to the secondary's explicit DBSERVERNAME, per the official guidance, to connect read-only.
  2. Bring up the HDR primary server, per the official guidance, to resume transaction processing via the group name, or
  3. Convert the HDR secondary to standard mode, per the official guidance.
Examples
N/A

No specific triggering statement is documented beyond a group-name connection attempt while the primary is down.

Diagnostic Checks
  1. Check the HDR pair's current state (primary availability, secondary mode), and choose the appropriate resolution above.
Related Errors / Related Topics

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

A group-name connection couldn't reach an HDR secondary while the primary was down — use the secondary's explicit DBSERVERNAME, restore the primary, or convert the secondary to standard mode.