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

CONCURRENT RUNNING OF THE INCREMENTAL BACKUP AND LOAD MAY CAUSE DB2 TO
CRASH

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
When ran concurrently, the online incremental backup and data 
load may cause DB2 to crash and dump the stack traces and agents 
dump files to the DB2 diagnostic log path. Following entries 
will typically appear in the db2diag.log file: 
 
1. Start of Load operation: 
 
2012-07-27-16.50.02.089000+120 I4682876F481       LEVEL: Warning 
PID     : 2040                 TID  : 9652        PROC : 
db2syscs.exe 
INSTANCE: DB2                  NODE : 000         DB   : xxx 
APPHDL  : 0-27973              APPID: *LOCAL.DB2.120727130831 
AUTHID  : xxx 
EDUID   : 9652                 EDUNAME: db2agent (xxx) 
FUNCTION: DB2 UDB, database utilities, sqluvtld_route_in, 
probe:839 
DATA #1 : <preformatted> 
Starting LOAD operation (S) (3) (I). 
 
 
 
2. Start of online incremental delta backup 
 
2012-07-27-18.30.59.410000+120 E4707301F477       LEVEL: Info 
PID     : 2040                 TID  : 9740        PROC : 
db2syscs.exe 
INSTANCE: DB2                  NODE : 000         DB   : xxx 
APPHDL  : 0-29149              APPID: *LOCAL.DB2.120727163224 
AUTHID  : xxx 
EDUID   : 9740                 EDUNAME: db2agent (xxx) 
FUNCTION: DB2 UDB, database utilities, sqlubSetupJobControl, 
probe:1604 
MESSAGE : Starting an online incremental delta db backup. 
 
 
 
3. DB2 crash : 
 
2012-07-27-20.40.32.891000+120 I4709246F582       LEVEL: Severe 
PID     : 2040                 TID  : 4248        PROC : 
db2syscs.exe 
INSTANCE: DB2                  NODE : 000         DB   : xxx 
APPHDL  : 0-29149              APPID: *LOCAL.DB2.120727163224 
AUTHID  : xxx 
EDUID   : 4248                 EDUNAME: db2bm.9740.0 (xxx) 
FUNCTION: DB2 UDB, RAS/PD component, 
pdResilienceIsSafeToSustain, probe:800 
DATA #1 : String, 37 bytes 
Trap Sustainability Criteria Checking 
DATA #2 : Hex integer, 8 bytes 
0x2000000303008808 
DATA #3 : Boolean, 1 bytes 
false 
 
Following stack will be produced for a failed agent: 
 
sqmLockEvents::collectRequestorActivities 
sqmLockEvents::collectLockEvent 
sqlplnfd 
sqlplrq 
SqlubTableLock::request 
sqlubReadSMS 
sqlubBMCont 
sqlubbuf 
sqleSubCoordProcessRequest 
sqeAgent::RunEDU 
sqlzRunEDU 
sqloEDUEntry
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All users running DB2 v9.7 FP7 and earlier                   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 v9.7 FP8                                      * 
****************************************************************
Local-Fix:
If possible, avoid running the incremental online backup and 
LOAD at the same time.
verfügbare FixPacks:
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
The problem was fixed in DB2 v9.7 FP8
Workaround
See Error Description
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
18.09.2012
08.04.2013
08.04.2013
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP8
Problem behoben lt. FixList in der Version
9.7.0.8 FixList