Oninit
Talk to an expert →

Informix Error -915

-915 Cannot create an IBM Informix SE database from an IBM Informix

Dynamic Server client.

This CREATE DATABASE statement cannot be carried out because the database server on your workstation and the one in the other computer system are different products: one is IBM Informix SE and the other is another IBM Informix database server. You can manipulate databases in this configuration, but you cannot create one.

To create a database, either start the same product in both locations, or run this statement locally on the other computer system.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-915 is the mirror image of -910: it fires when CREATE DATABASE is attempted from a Dynamic Server client targeting a remote SE server (rather than the other direction) — per the official guidance, the same product-mismatch restriction applies regardless of which side is which; creating a database across mismatched Informix products isn't supported, though manipulating an already-existing one is.

  1. CREATE DATABASE issued from a Dynamic Server client targeting a remote SE server, per the official guidance — the direct, only cause.
  2. A workflow that mixes creating databases with ordinary cross-product data access, the same underlying confusion as -910.
Solutions / Resolution
  1. Start the same product in both locations, per the official guidance, if feasible, then retry CREATE DATABASE.
  2. Or run the CREATE DATABASE statement locally on the other computer system, per the official guidance — connect directly to that system and create the database there.
  3. Once the database exists, ordinary cross-product manipulation is supported, per the official guidance — this restriction is specific to the creation step.
Examples
Creating the database locally on the target system instead
-- Instead of creating remotely from a mismatched-product client:
-- CREATE DATABASE stores_se@remote_se_server;  -- -915

-- Connect to remote_se_server directly (using its own SE product)
-- and run CREATE DATABASE there instead.
Diagnostic Checks
  1. Confirm which Informix product is running locally and which is running on the target remote server, and whether they match, before attempting a remote CREATE DATABASE.
Related Errors / Related Topics
  • -910 — "Cannot create an IBM Informix Dynamic Server database from an IBM Informix SE client." The mirror-image restriction, on the opposite direction of the same product-mismatch rule.

The mirror image of -910 — create the database locally on the target system instead of remotely from a mismatched-product client.