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 |