Informix Error -9202: JVTI only supports external am_sptype in this release.

Cause and resolution

JVTI only supports external am_sptype in this release.

Your CREATE PRIMARY ACCESS_METHOD SQL statement specified an am_sptype value other than "X". JVTI allows you to address only extspace (not sbspace or dbspace) data storage.

Use the ALTER ACCESS_METHOD SQL statement to change am_sptype to 'X'.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-9202 fires when a CREATE PRIMARY ACCESS_METHOD statement specifies an am_sptype value other than X — per the official guidance.

An am_sptype other than X (external/extspace), per the official guidance — the direct, only cause; JVTI can only address extspace storage, not sbspace or dbspace.

Solutions / Resolution

Use the ALTER ACCESS_METHOD statement to change am_sptype to 'X', per the official guidance.

Examples

Creating a primary access method with an unsupported storage type

CREATE PRIMARY ACCESS_METHOD my_am (am_sptype = 'B');   -- -9202: 'B' not supported

Corrected

ALTER ACCESS_METHOD my_am (am_sptype = 'X');

Diagnostic Checks

Check the am_sptype value used in CREATE/ALTER ACCESS_METHOD, and set it to 'X'.

Related Errors / Related Topics

-9200 — "Purpose routine (am_xxx) is not yet supported with JVTI." A related JVTI feature-coverage limitation, on purpose routines rather than storage type.
-9201 — "Secondary access method with Java am_purpose routine is not supported." A related JVTI feature-coverage limitation, on secondary access methods rather than storage type.

The access method specified a storage type other than external ('X') — JVTI only supports extspace storage in this release; use ALTER ACCESS_METHOD to correct it.