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

RUNSTATS RESULTS IN DB2 CRASH WHEN USER DROPS THE EXISTING TABLE COLUMNS
BETWEEN SET PROFILE AND USE PROFILE

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
Runstats 'USE PROFILE' option results in DB2 crash due to memory 
corruption. 
The memory corruption happens if user has set the profile with 
explicit column names for basic and distribution statistics 
collection and an 'ALTER TABLE' to drop the existing columns has 
been performed between SET PROFILE and USE PROFILE execution.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* See SYSROUTE APARs to see where this APAR is addressed       * 
****************************************************************
Local-Fix:
As a workaround, user can set the profile once again after 
performing 'alter table drop column' ensuring only existing 
columns are specified in  runstats set profile command.
Lösung
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
24.11.2014
09.05.2017
09.05.2017
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.7 FixList