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 |