home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
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 IC67222 Status: Closed

UNEXPECTED SQLCODE RETURNED FROM API DB2GETROWPARTNUM AND
DB2GETDISTMAP DUE TO NOT INITIALIZED SQLCA.

product:
DB2 FOR LUW / DB2FORLUW / 980 - DB2
Problem description:
Calling API db2GetRowPartNum and db2GetDistMap will probably 
result in unexpected sqlcode, since they do not initialize 
sqlca. 
 
The initialization is being done in a separate functions which 
aren't being called since db2 LUW v9.7. 
 
The fix is to move the initialization code in db2GetRowPartNum 
and db2GetDistMap.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL.                                                         * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* etRowPartNum and db2GetDistMap will probably result in       * 
* unexpected sqlcode, since they do not initialize sqlca.      * 
*                                                              * 
* The initialization is being done in a separate functions     * 
* which aren't being called since db2 LUW v9.7.                * 
*                                                              * 
* The fix is to move the initialization code in                * 
* db2GetRowPartNum and db2GetDistMap.                          * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to version 9.8 fixpack3 or later fixpacks.            * 
****************************************************************
Local Fix:
Initialize sqlca explicitly before calling db2GetRowPartNum  or 
db2GetDistMap in application, for example, memsetting the struct 
sqlca with \0.
available fix packs:
DB2 Version 9.8 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.8 Fix Pack 4 for AIX and Linux
DB2 Version 9.8 Fix Pack 5 for AIX and Linux

Solution
This problem is first fixed in version 9.8 fixpack 3.
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
15.03.2010
23.12.2010
23.12.2010
Problem solved at the following versions (IBM BugInfos)
9.8.,
9.8.FP3
Problem solved according to the fixlist(s) of the following version(s)
9.8.0.3 FixList