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 IC63112 Status: Closed

ON IA32 PLATFORMS, AN APPLICATION MAY RECEIVE A -902 IN SQLPGR()PROBE 9120
WITH 'SQLP_BADLSN'

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
In rare timing situations, on IA32 32bit platforms, due to a 
rare race condition, an internal 64bit value 
may be assigned only half it's byte value. This will cause an 
application to fail with the following 
db2diag.log entry from sqlpgrlg, probe:9120: 
 
2009-08-10-23.51.24.029905-240 I971292G525   LEVEL: Severe 
PID : 21670         TID  : 2405428128  PROC : 
db2syscINSTANCE: cct1        NODE : 000  DB   : 
CCTDB  APPHDL  : 0-48884       APPID: 
*LOCAL.cct1.090811074247  AUTHID  : CCT1 
    EDUID  : 217   EDUNAME: 
db2agent (CCTDB) FUNCTION: DB2 UDB, data protection 
services, sqlpgrlg,      probe:9120 
       DATA #1 : <preformatted> 
      diff 499, count 499, fromptr 
0x9096e203, CharPtr 0x9096f072,    pageLso 4294970872, 
LowPageLso 4294966797
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* In rare timing situations, on IA32 32bit platforms, due to a * 
*                                                              * 
* rare race condition, an internal 64bit value                 * 
*                                                              * 
* may be assigned only half it's byte value. This will cause   * 
* an                                                           * 
* application to fail with the following                       * 
*                                                              * 
* db2diag.log entry from sqlpgrlg, probe:9120:                 * 
*                                                              * 
*                                                              * 
*                                                              * 
* 2009-08-10-23.51.24.029905-240 I971292G525   LEVEL: Severe   * 
*                                                              * 
* PID : 21670         TID  : 2405428128  PROC :                * 
*                                                              * 
* db2syscINSTANCE: cct1        NODE : 000  DB   :              * 
*                                                              * 
* CCTDB  APPHDL  : 0-48884       APPID:                        * 
*                                                              * 
* *LOCAL.cct1.090811074247  AUTHID  : CCT1                     * 
*                                                              * 
*     EDUID  : 217   EDUNAME:                                  * 
*                                                              * 
* db2agent (CCTDB) FUNCTION: DB2 UDB, data protection          * 
*                                                              * 
* services, sqlpgrlg,      probe:9120                          * 
*                                                              * 
*        DATA #1 : <preformatted>                              * 
*                                                              * 
*       diff 499, count 499, fromptr                           * 
*                                                              * 
* 0x9096e203, CharPtr 0x9096f072,    pageLso 4294970872,       * 
*                                                              * 
* LowPageLso 4294966797                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to latest fixpak                                     * 
****************************************************************
Local Fix:
available fix packs:
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
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 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 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

Solution
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
10.09.2009
16.02.2010
16.02.2010
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.1 FixList