IBM Support

Resolving com.ibm.db2.jcc.a.SqlException with the SQLCODE of -433, and SQLSTATE of 22001

Troubleshooting


Problem

When using the Decision Warehouse with DB2 for z/OS version 9.1, you receive a com.ibm.db2.jcc.a.SqlException with the SQLCODE of -433, an SQLSTATE of 22001 and a reason code of "". This error indicates that an attempt to insert a LOB value has failed because the data is too large for the database. Typically this only happens when using rulesets with large numbers of rules (for example, over a few hundred).

[{"Product":{"code":"SS6MTS","label":"WebSphere ILOG JRules"},"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Component":"Not Applicable","Platform":[{"code":"PF035","label":"z\/OS"}],"Version":"7.1.1;7.1;7.0.2;7.0.1;7.0","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}},{"Product":{"code":"SSQP76","label":"IBM Operational Decision Manager"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":null,"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.5","Edition":"Enterprise","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
23 June 2018

UID

swg21415304

Page Feedback