Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC81921 Status: Closed

ERROR COULD OCCUR WHEN USING CHAR ARRAY IN EXTERNAL JAVA ROUTINE

product:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problem description:
When running an external Java routine that uses CHAR array or 
CHAR array for bit data as a parameter, sqlcode -1131 or -4302 
could be returned. 
 
SQL1131N  DARI (Stored Procedure) process has been terminated 
abnormally. 
SQLSTATE=38503 
 
SQL4302N  Procedure or user-defined function "xxxx.xxxx", 
specific name 
"SQLxxxxxxxxxxxxx" aborted with an exception "Incompatible base 
type for 
array".
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* When running an external Java routine that uses CHAR array   * 
* or                                                           * 
* CHAR array for bit data as a parameter, sqlcode -1131 or     * 
* -4302                                                        * 
* could be returned.                                           * 
*                                                              * 
* SQL1131N  DARI (Stored Procedure) process has been           * 
* terminated                                                   * 
* abnormally.                                                  * 
* SQLSTATE=38503                                               * 
*                                                              * 
* SQL4302N  Procedure or user-defined function "xxxx.xxxx",    * 
* specific name                                                * 
* "SQLxxxxxxxxxxxxx" aborted with an exception "Incompatible   * 
* base                                                         * 
* type for                                                     * 
* array".                                                      * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* See local fix or upgrade to DB2 LUW version 9.5 fixpack 10.  * 
****************************************************************
Local Fix:
switching to VARCHAR could avoid the problem
Solution
Problem is first fixed in DB2 LUW version 9.5 fixpack 10.
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC82073 IC84510 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
08.03.2012
29.01.2013
29.01.2013
Problem solved at the following versions (IBM BugInfos)
9.5.FP10
Problem solved according to the fixlist(s) of the following version(s)
9.5.0.10 FixList