home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC64845 Status: Geschlossen

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

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
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-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL.                                                         * 
**************************************************************** 
* 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.                                           * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to version 9.7 fix pack 2 or later.                   * 
****************************************************************
Local-Fix:
Initialize sqlca explicitly before calling db2GetRowPartNum  or 
db2GetDistMap in application, for example, memsetting the struct 
sqlca with \0.
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
This problem is first fixed in version 9.7 fix pack 2.
Workaround
Initialize sqlca explicitly before calling db2GetRowPartNum  or 
db2GetDistMap in application, for example, memsetting the 
 
struct 
sqlca with \0.
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC67222 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
27.11.2009
25.05.2010
25.05.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP2
Problem behoben lt. FixList in der Version
9.7.0.2 FixList