Informix Error -9201: Secondary access method with Java am_purpose routine is not supported.

Cause and resolution

Secondary access method with Java am_purpose routine is not supported.

You attempted to create a secondary access method with Java-Language User Defined Routines. Secondary access methods are not supported in Java technology.

To create a secondary access method, you must use the C language User Defined Routines. For more information, see the Virtual-Index Interface Programmer's Guide.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-9201 fires when attempting to create a secondary access method using Java-language User Defined Routines — per the official guidance.

Attempting to create a secondary access method with Java UDRs, per the official guidance — the direct, only cause; secondary access methods aren't supported in Java technology at all.

Solutions / Resolution

Use C-language User Defined Routines to create the secondary access method instead, per the official guidance.
See the Virtual-Index Interface Programmer's Guide for more information, per the official guidance.

Examples

N/A

No specific triggering statement is documented beyond attempting a Java-based secondary access method.

Diagnostic Checks

Check whether the access method being created is primary or secondary, and use C-language UDRs if it's secondary.

Related Errors / Related Topics

-9200 — "Purpose routine (am_xxx) is not yet supported with JVTI." A related JVTI feature-coverage limitation, on specific purpose routines rather than secondary access methods as a whole.
-9202 — "JVTI only supports external am_sptype in this release." A related JVTI feature-coverage limitation, on storage type rather than secondary access methods.

Secondary access methods aren't supported with Java UDRs at all — use C-language UDRs instead.