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