Informix Error -9251: Xadatasource datasource_name already exists in database.

Cause and resolution

Xadatasource datasource_name already exists in database.

The xadatasource that you are creating with a CREATE XADATASOURCE datasource_name USING statement already exists. You must use a new name.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-9251 fires when a CREATE XADATASOURCE ... USING statement names an xadatasource that already exists in the database — per the official guidance.

A CREATE XADATASOURCE statement reusing an existing datasource name, per the official guidance — the direct, only cause.

Solutions / Resolution

Use a new, unused name for the xadatasource, per the official guidance.

Examples

Recreating an existing xadatasource

CREATE XADATASOURCE ds1 USING xads_t1 (...);   -- -9251 if ds1 already exists

Corrected

CREATE XADATASOURCE ds2 USING xads_t1 (...);

Diagnostic Checks

Check the system catalog for the existing xadatasource name, and choose an unused name.

Related Errors / Related Topics

-9250 — "Xadatasource type datasource_type_name already exists in database." The same class of duplicate-name error, for xadatasource types rather than instances.
-9253 — "Xadatasource datasource_name not found." The inverse case — dropping a name that doesn't exist.

The named xadatasource already exists — choose a new, unused name.