Informix Error -9853: Duplicate purpose purpose_name used for access method.

Cause and resolution

Duplicate purpose purpose_name used for access method.

A purpose used with the CREATE ACCESS_METHOD or ALTER ACCESS_METHOD statement has been used more than once. Change the purposes used until no duplicates exist.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-9853 fires when a purpose is used more than once in a CREATE/ALTER ACCESS_METHOD statement — per the official guidance.

A purpose assigned to more than one purpose slot, per the official guidance — the direct, only cause.

Solutions / Resolution

Change the purposes used until no duplicates exist, per the official guidance.

Examples

N/A

No specific triggering statement is documented; the specific duplicated purpose varies.

Diagnostic Checks

Check each purpose slot in the CREATE/ALTER ACCESS_METHOD statement for a purpose reused in more than one slot.

Related Errors / Related Topics

-9852 — "Improper purpose purpose_name used for access method." A related purpose- validity error, on impropriety/misspelling rather than duplication.
-9854 — "Required purpose purpose_name not used for access method." A related purpose-validity error, on a missing required purpose rather than a duplicated one.

A purpose was assigned to more than one purpose slot — remove the duplicate.