DB2 - Problem description
Problem IC86272 | Status: Closed |
A ROWTYPE WITH MORE THAN 84 COLUMNS FOLLOWED BY A ROW TYPE WITH LESS THAN 84 COLUMNS CAUSES COMMUNICATION ERRORS. | |
product: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problem description: | |
If a stored procedure has a parameter of row type with more than 84 columns, the JCC application fails with error: com.ibm.db2.jcc.am.DisconnectRecoverableException: [jcc][t4][2034][11148][3.63.75] Execution failed due to a distribution protocol error that caused deallocation of the conversation. Detect DRDA data flow syntax error. Reason: 0x12. ERRORCODE=-4499, SQLSTATE=58009 Both JCC and DB2 server side fix should be applied. APAR IC80464 open for JCC driver. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All V9.7 DB2 LUW users. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 V9.7 Fixpack 7. * **************************************************************** | |
Local Fix: | |
available fix packs: | |
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows | |
Solution | |
The issue is fixed in DB2 V9.7 Fixpack 7. | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 31.08.2012 11.02.2013 11.02.2013 |
Problem solved at the following versions (IBM BugInfos) | |
9.7.FP7 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.7.0.7 |