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 IC84023 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 / 970 - 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:                                              * 
* db2 CLP users performing load operations                     * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* upgrade to v97fp7 or later                                   * 
****************************************************************
Local-Fix:
NA
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
Problem fixed
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC87916 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
08.06.2012
05.11.2012
05.11.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP7
Problem behoben lt. FixList in der Version
9.7.0.7 FixList