Oninit
Talk to an expert →

Informix Error -29009: DDM parameter value (parameter,parameter-value) not supported. Disconnected from AS.

Cause and resolution

DDM parameter value (parameter,parameter-value) not supported. Disconnected from AS.

The remote RDB received an unsupported/unrecognized parameter value for a DDM parameter. The current SQL statement is terminated. The application is disconnected from the application server.

The hexadecimal codepoints of the DDM parameter and the parameter value in question are returned as a token in SQLERRM.

To interpret the hexadecimal codepoints of the DDM parameter and the parameter value requires DDM knowledge.

Attempt to rerun the application. If the problem persists, notify the DBA for assistance in analyzing the SQL statement that yields this SQLCODE. If the error recurs, note all circumstances and contact IBM Informix Technical Support.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-29009 fires when the remote RDB receives an unsupported/unrecognized value for a DDM parameter — per the official guidance, the current SQL statement is terminated and the application is disconnected. The hexadecimal codepoints of the parameter and its value are returned as tokens in SQLERRM.

  1. An unsupported/unrecognized value supplied for a DDM parameter, per the official guidance — the direct, only cause.
Solutions / Resolution
  1. Rerun the application, per the official guidance.
  2. If the problem persists, notify the DBA for analysis of the triggering SQL statement, per the official guidance.
  3. If the error recurs, note all circumstances and contact IBM Informix Technical Support, per the official guidance.
Examples
N/A

No specific triggering statement is documented beyond an unsupported DDM parameter value.

Diagnostic Checks
  1. Extract the parameter and value codepoints from SQLERRM, rerun the application, and escalate to the DBA if it persists.
Related Errors / Related Topics
  • -29008 — "DDM parameter (parameter-codepoint) not supported error. Disconnected from AS." A related DDM error, on an unsupported parameter itself rather than its value.
  • -29010 — "AS reply message (codepoint=codepoint) not supported by Gateway." A related unsupported-DDM-element error, on a reply message received by the Gateway.

The remote RDB received an unsupported DDM parameter value and disconnected — rerun the application, escalating to the DBA if it persists.