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

PD CORRUPTION ON TABLE AFTER ALTER TABLE ADD OR REMOVE A COLUMN WHEN RTS IS
ENABLED

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
RTS is enabled and there is successive asynchronous write 
operation happening. In the meantime if user does add or remove 
column it will result is PD corruption. 
 
SQL runs against the table will cause unpredictable results like 
instance crash with memory corruption. 
 
Sample stack: 
 
0x09000000117DDE0C MemTreeDelete__FPP8SMemNode + 0x10 
0x09000000117DE0D0 
.MemTreePut.fdpr.clone.224__13SQLO_MEM_POOLFP8SMemNodeUlP17SqloC 
hunkSubgroup + 0x1D4 
0x09000000117DE6EC sqlofmblkEx + 0x288 
0x09000000117BB55C sqlofmblkEx@glue801 + 0x78 
0x09000000116B8AA8 
sqlra_sqlW_mem_free_sibling_list__FP8sqlrr_cbP23sqlra_workspace_ 
siblingPUl + 0x240 
0x09000000117E1EA8 sqlra_sqlW_mem_freespace__FP8sqlrr_cbUlPUli + 
0x224 
0x09000000117E183C 
sqlra_sqlW_check_for_cleanup__FP8sqlrr_cbUlP7OSSTick + 0x204 
0x0900000011A6E7D0 
sqlra_sqlW_get_dynamic_section__FP8sqlrr_cbP16sqlra_cached_var + 
0xB1C 
0x0900000011A72ED8 
sqlra_load_var__FP8sqlrr_cbP16sqlra_cached_var + 0x8C 
0x0900000011A72B60 sqlra_get_var__FP8sqlrr_cbiT2bPbT5 + 0x2E4 
0x0900000012168518 
sqlrr_prepare__FP14db2UCinterfaceP16db2UCprepareInfo + 0xC8 
0x0900000014516FF0 
sqljs_ddm_prpsqlstt__FP14db2UCinterfaceP13sqljDDMObject + 0xC74 
0x090000001160AE3C 
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC 
interface + 0x228 
 
Running db2cat to get table information shows wrong number of 
columns returned. 
 
Select colname,colno from syscat.columns where 
tabname='TABLE_NAME' might show duplicate column number for 
different columns.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 UDB users                                                * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 v9.7 Fixpak 10                                * 
****************************************************************
Local-Fix:
Lösung
Problem first fixed in v9.7 Fixpack 10
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC99629 IC99630 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
24.02.2014
15.12.2014
15.12.2014
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.,
9.7.FP10
Problem behoben lt. FixList in der Version
9.7.0.10 FixList