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

LOAD WITH CLIENT OPTION (OR CLI LOAD) THAT IS INTERRUPTED MAY TRAP WITH
SQLODIAGNOSEFREEBLOCKFAILURE.

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
When the Load utility is invoked from a remotely connected 
client and the CLIENT option is specified (meaning data is being 
retrieved from the client), or the CLI Load interface is used, 
if the utility is interrupted or fails, it's possible in some 
timing situations that the Load Agent process drives a rollback 
and free's resources before all of it's child processes have 
exited, causing the Load to trap with errors such as this: 
 
2009-04-07-15.32.51.513504-240 I4089969E2013       LEVEL: Severe 
PID     : 12699                TID  : 208729532768 PROC : 
db2sysc 0 
INSTANCE: xxx             NODE : 000          DB   :xxx 
 
APPHDL  : 0-38628              APPID:P00000.D289.004E97180854 
AUTHID  : Kxxxx 
EDUID   : 3479                 EDUNAME: db2lfrm0 0 
FUNCTION: DB2 UDB, SQO Memory Management, 
sqloDiagnoseFreeBlockFailure, probe:60 
MESSAGE : The associated pool has already been freed.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All users of db2v97 or greater                               * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* LOAD from client from remote client is interrupted, and      * 
* causes crash with diaglog message:                           * 
* sqloDiagnoseFreeBlockFailure, probe:60                       * 
*                                                              * 
* MESSAGE : The associated pool has already been freed.        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 2 or later.              * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
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

Lösung
DB2 Version 9.7 Fix Pack 2 contains fix
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
08.10.2009
01.03.2010
01.03.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP2
Problem behoben lt. FixList in der Version
9.7.0.1 FixList