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

Load utility with COPY YES can trap in rare timing scenarios.

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
The Load utility when invoked with the COPY YES option, may trap 
or fail in very rare timing scenarios.  The trap or failure may 
have different signatures, but one such signature would be a 
db2diag.log message such as: 
 
2009-11-24-11.03.18.377754-300 I541128E585           LEVEL: 
Error 
PID     : 12286                TID  : 47630323280192 KTID : 
15378 
PROC    : db2sysc 0 
 
EDUID   : 360                  EDUNAME: db2lbm0 0 
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0 
DATA #1 : String, 149 bytes 
LOADID: 171.2009-11-24-11.03.02.577583.0 (65530;32768) 
Cannot set direct write CB - logic error. , 32, 0x8000, Detected 
in file:sqlulbuf.C, Line:2513 
 
A higher probability of hitting the problem with MDC/RP tables, 
low available memory, and logical DPF setup/high 
system CPU load.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* The Load utility when invoked with the COPY YES option, may  * 
* trap                                                         * 
* or fail in very rare timing scenarios.  The trap or failure  * 
* may                                                          * 
* have different signatures, but one such signature would be a * 
*                                                              * 
* db2diag.log message such as:                                 * 
*                                                              * 
*                                                              * 
*                                                              * 
* 2009-11-24-11.03.18.377754-300 I541128E585           LEVEL:  * 
*                                                              * 
* Error                                                        * 
*                                                              * 
* PID     : 12286                TID  : 47630323280192 KTID :  * 
*                                                              * 
* 15378                                                        * 
*                                                              * 
* PROC    : db2sysc 0                                          * 
*                                                              * 
*                                                              * 
*                                                              * 
* EDUID   : 360                  EDUNAME: db2lbm0 0            * 
*                                                              * 
* FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0   * 
*                                                              * 
* DATA #1 : String, 149 bytes                                  * 
*                                                              * 
* LOADID: 171.2009-11-24-11.03.02.577583.0 (65530;32768)       * 
*                                                              * 
* Cannot set direct write CB - logic error. , 32, 0x8000,      * 
* Detected                                                     * 
* in file:sqlulbuf.C, Line:2513                                * 
*                                                              * 
*                                                              * 
*                                                              * 
* A higher probability of hitting the problem with MDC/RP      * 
* tables,                                                      * 
* low available memory, and logical DPF setup/high             * 
*                                                              * 
* system CPU load.                                             * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to product version 9.7 fixpack 2                     * 
****************************************************************
Local-Fix:
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
Problem was first fixed in Version 9.7 fixpack 2 
The fix should be applied on the server
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
01.12.2009
26.01.2010
26.01.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP2
Problem behoben lt. FixList in der Version
9.7.0.2 FixList