|
Problem IC99594
|
Status: Closed |
PD CORRUPTION ON TABLE AFTER ALTER TABLE ADD OR REMOVE A COLUMN WHEN RTS IS ENABLED |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* USERS AFFECTED: *
* DB2 UDB users *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 v9.7 Fixpak 10 *
**************************************************************** |
| Local Fix: |
|
| Solution |
Problem first fixed in v9.7 Fixpack 10 |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC99629 IC99630
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 24.02.2014
15.12.2014
15.12.2014 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.,
9.7.FP10
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.10
|
 |
