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

AFTER RECEIVING SQL0437W WARNING FROM THE LOAD CLIENT WHILE PERF ORMING
LOAD FROM CURSOR, CLP CRASHES THE BACKGROUND DB2BP PROCES

Produkt:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problembeschreibung:
After receiving SQL0437W warning from the Load client while 
performing load from cursor, CLP crashes the background db2bp 
process when attempting to re-execute the load as per user 
supplied option via prompt. 
 
Following two stacks could be seen in db2diag.log 
 
  [0] 0x0900000002FF6CD4 pdLog + 0xA8 
  [1] 0x0900000003175E2C 
@28@sqloDiagnoseFreeBlockFailure__FP8SMemFBlk + 0x15C 
  [2] 0x0900000003838ED4 sqlofmblkEx + 0x88 
  [3] 0x0900000002F5E46C clpPostLoadFreeDynMem + 0xB0 
  [4] 0x00000001000422B0 clpbp_exe_sqluload__Fv + 0x130 
  [5] 0x0000000100001794 clp_bp_con__Fv + 0x634 
  [6] 0x0000000100000B24 main + 0x224 
  [7] 0x0000000100000320 __start + 0x98 
  [8] 0x0000000000000000 ?unknown + 0x0 
  [9] 0x0000000000000000 ?unknown + 0x0 
...... 
...... 
  [0] 0x090000000F005A18 pdLog + 0xA8 
  [1] 0x090000000F185814 
@28@sqloDiagnoseFreeBlockFailure__FP8SMemFBlk + 0x14C 
  [2] 0x090000000EBC4190 sqlofmblkEx + 0x41C 
  [3] 0x0000000100003800 clp_send_cmdcb__Fv + 0x220 
  [4] 0x0000000100042260 clpbp_exe_sqluload__Fv + 0xE0 
  [5] 0x0000000100001794 clp_bp_con__Fv + 0x634 
  [6] 0x0000000100000B24 main + 0x224 
  [7] 0x0000000100000320 __start + 0x98 
  [8] 0x0000000000000000 ?unknown + 0x0 
  [9] 0x0000000000000000 ?unknown + 0x0 
 
It is also possible that user might enter an infinite prompting 
scenario where any keyboard input might just lead to infinite 
iteration of the same prompt. 
ctrl+c + enter might end the infinite loop, but memory 
corruption would already have occurred at that point in time.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* clp users                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* fixed in v101fp2                                             * 
****************************************************************
Local-Fix:
NA
verfügbare FixPacks:
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows

Lösung
problem fixed
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
04.11.2012
18.12.2012
18.12.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.1.0.2 FixList
10.5.0.2 FixList