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 IC82217 Status: Geschlossen

ON IA32 PLATFORM(WINDOWS OR LINUX), DATABASE MARKED BAD DUE TO SQLP_BADLSN
FOUND

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
On IA32 platforms, due to an internal non-atomic write of a 64 
bit value on 32-bit operating systems, an application may fail 
with the error "SQL1034C The database is damaged...". 
You can find SQLP_BADLSN error in db2diag.log. The following is 
a snippet of db2diag.log: 
 
2012-02-16-10.51.27.468000+060 I3684517H548       LEVEL: Severe 
 
PID     : 2464                 TID  : 5424        PROC : 
db2syscs.exe 
INSTANCE: DB2                  NODE : 000         DB   : SAMPLE 
 
APPHDL  : 0-26951              APPID: 
9.36.30.159.4691.120216094200 
AUTHID  : SAMPLE03 
 
EDUID   : 5424                 EDUNAME: db2agent (SAMPLE) 0 
 
FUNCTION: DB2 UDB, data protection services, sqlpgrlg, 
probe:9120 
DATA #1 : <preformatted> 
 
diff 47, count 47, fromptr 7F4BA03F, CharPtr 7F4BB171, pageLso 
 
1821066137532, LowPageLso 1821066133457 
 
 
 
2012-02-16-10.51.27.484000+060 I3685067H541       LEVEL: Severe 
 
PID     : 2464                 TID  : 5424        PROC : 
db2syscs.exe 
INSTANCE: DB2                  NODE : 000         DB   : SAMPLE 
 
APPHDL  : 0-26951              APPID: 
9.36.30.159.4691.120216094200 
AUTHID  : SAMPLE03 
 
EDUID   : 5424                 EDUNAME: db2agent (SAMPLE) 0 
 
FUNCTION: DB2 UDB, data protection services, sqlpgrlg, 
probe:9120 
DATA #1 : <preformatted> 
 
rc -2028994519, pageByteCount 4076, pageLso 1821066137532 
LookForLso 
1821066133504, Bp 7F4BA000 
 
 
 
2012-02-16-10.51.27.484000+060 I3685610H152       LEVEL: Severe 
 
PID:2464 TID:5424 NODE:000 Title: SQLP_LFPB 
 
Dump File: c:\DB2\2464.5424.000.dump.bin 
 
 
 
2012-02-16-10.51.27.515000+060 I3685764H1085      LEVEL: Error 
 
PID     : 2464                 TID  : 5424        PROC : 
db2syscs.exe 
INSTANCE: DB2                  NODE : 000         DB   : SAMPLE 
 
APPHDL  : 0-26951              APPID: 
9.36.30.159.4691.120216094200 
AUTHID  : SAMPLE03 
 
EDUID   : 5424                 EDUNAME: db2agent (SAMPLE) 0 
 
FUNCTION: DB2 UDB, data protection services, sqlpgrlg, 
probe:2510 
DATA #1 : <preformatted> 
 
 -2028994519 when reading LSO 1821066133504 from log file 
S0090067.LOG 
dpsAgtCbFlags 0 setSkipOutputBuf 0 
 
CALLSTCK: 
 
  [0] 0x6CD37526 pdLogPrintf + 0x2F8 
 
  [1] 0x6F2A0C88 
 
_VInfreq_?sqlpgrlgYAHPAVsqeAgentI_KIPADPAUSQLO_MEM_POOLPAUSQLP_L 
RHPAPADZ 
+ 0x24C 
 
  [2] 0x6E146D9F sqlpReadLogForCC + 0x97 
 
  [3] 0x6D72B35C sqldGetCurrentlyCommitted + 0x13E 
 
  [4] 0x6EF49063 _VInfreq_?sqldReadNormYAHPAUSQLD_DFM_WORKHZ + 
0x56F 
  [5] 0x6D728665 sqldfrd + 0xF09 
 
  [6] 0x6D727859 sqldfrd + 0xFD 
 
  [7] 0x6D6B560A sqldRowFetch + 0x358 
 
  [8] 0x6E498B53 sqlritaSimplePerm + 0xAB 
 
  [9] 0x6E495471 ?sqlriunn.@@YAHPAUsqlrr_cb@@PAUsqlri_stob@@@Z + 
0x23D 
 
 
2012-02-16-10.51.27.875000+060 I3686851H1026      LEVEL: Severe 
 
PID     : 2464                 TID  : 5424        PROC : 
db2syscs.exe 
INSTANCE: DB2                  NODE : 000         DB   : SAMPLE 
 
APPHDL  : 0-26951              APPID: 
9.36.30.159.4691.120216094200 
AUTHID  : SAMPLE03 
 
EDUID   : 5424                 EDUNAME: db2agent (SAMPLE) 0 
 
FUNCTION: DB2 UDB, data protection services, sqlpgrlg, 
probe:2510 
DATA #1 : <preformatted> 
 
HeadLsn 000001AA10530CBE, reqlso 1821066133504 
 
CALLSTCK: 
 
  [0] 0x6CD37526 pdLogPrintf + 0x2F8 
 
  [1] 0x6F2A0CDA 
 
_VInfreq_?sqlpgrlgYAHPAVsqeAgentI_KIPADPAUSQLO_MEM_POOLPAUSQLP_L 
RHPAPADZ 
+ 0x29E 
 
  [2] 0x6E146D9F sqlpReadLogForCC + 0x97 
 
  [3] 0x6D72B35C sqldGetCurrentlyCommitted + 0x13E 
 
  [4] 0x6EF49063 _VInfreq_?sqldReadNormYAHPAUSQLD_DFM_WORKHZ + 
0x56F 
  [5] 0x6D728665 sqldfrd + 0xF09 
 
  [6] 0x6D727859 sqldfrd + 0xFD 
 
  [7] 0x6D6B560A sqldRowFetch + 0x358 
 
  [8] 0x6E498B53 sqlritaSimplePerm + 0xAB 
 
  [9] 0x6E495471 ?sqlriunn.@@YAHPAUsqlrr_cb@@PAUsqlri_stob@@@Z + 
0x23D 
 
2012-02-16-10.51.28.125000+060 I3696872H559       LEVEL: Severe 
PID     : 2464                 TID  : 5424        PROC : 
db2syscs.exe 
INSTANCE: DB2                  NODE : 000         DB   : SAMPLE 
APPHDL  : 0-26951              APPID: 
9.36.30.159.4691.120216094200 
AUTHID  : SAMPLE03 
EDUID   : 5424                 EDUNAME: db2agent (SAMPLE) 0 
FUNCTION: DB2 UDB, data management, sqldRowFetch, probe:666 
RETCODE : ZRC=0x87100029=-2028994519=SQLP_BADLSN "Invalid LSN 
value." 
          DIA8538C An invalid log sequence number (LSN), the 
value was "".
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Prior to DB2 V9.7 FP7                                        * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V9.7 FP7                                      * 
****************************************************************
Local-Fix:
Set database parameter CUR_COMMIT to DISABLED
verfügbare FixPacks:
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 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
First Fixed in DB2 V9.7 Fixpack 7
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC86709 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
23.03.2012
25.10.2012
25.10.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP7
Problem behoben lt. FixList in der Version
9.7.0.7 FixList