Informix Error -43207: Unable to open connection to database server: <server-name>. </server-name>

Reasons / Common Causes

-43207 fires when the named database server is in the wrong operating mode for the requested operation — per the official guidance.

1. The server not being in the required mode for the operation, per the official guidance — a backup needs online or quiescent mode; a warm restore needs online, quiescent, backup, or recovery mode; a cold restore needs the server off-line (IBM Informix Dynamic Server 9.2x+) or in microkernel mode (IBM Informix Extended Parallel Server).

Solutions / Resolution

1. Bring the server to the correct mode for the operation, per the official guidance, using onmode or oninit.

Examples

Bringing the server to the correct mode

$ onmode -sy      # quiescent mode, for a backup
$ onmode -ky      # off-line, for a cold restore
$ oninit          # bring the server up in the last-configured mode

Diagnostic Checks

1. Check the server's current operating mode, and bring it to the mode the intended operation (backup, warm restore, or cold restore) requires.

Related Errors / Related Topics

• -43206 — "An attempt to change the database server operating mode failed: ." A related operating-mode error, on the mode-change attempt itself failing rather than the server already being in the wrong mode.

The database server was in the wrong operating mode for the requested backup/restore operation — bring it to the required mode via onmode/oninit.