DB2 - Problembeschreibung
Problem IC63954 | Status: Geschlossen |
Instance possibly traps if ALTER TABLE statement fails while catalog cache space management is running concurrently. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
If an alter statement fails on a table containing dependent views, there is a small timing window which can cause the instance to trap if cache space management is running concurrently. The following stack can be used to identify this APAR: <StackTrace> -------Frame------ ------Function + Offset------ 0x090000002CEA318C sqlrlc_find_invalidate__FP8sqlrr_cbP10sqlrlc_keyUiP8SQLZ_RID + 0x84C 0x090000002CEC2180 sqlrlc_end_uow__FP8sqlrr_cbiP19sqlr_savepoint_info + 0x260 0x090000002D7AE804 sqlrr_rbk_cleanup_mem__FP8sqlrr_cbiP19sqlr_savepoint_info + 0x104 0x090000002D7AF030 sqlrr_stmt_rbk_svpt__FP8sqlrr_cbP19sqlr_savepoint_infoi + 0x290 0x090000002D7BF8D4 sqlrr_sub_rrsvpt__FP8sqlrr_cbi + 0x14F4 0x090000002CDBAF04 sqlrr_subagent_router__FP8sqeAgentP12SQLE_DB2RA_T + 0x17A4 0x090000002CCEC268 sqleSubRequestRouter__FP8sqeAgentPUiT2 + 0xB28 0x090000002CCF6F30 sqleProcessSubRequest__FP8sqeAgent + 0x190 0x090000002B9F3AD0 RunEDU__8sqeAgentFv + 0x2F0 0x090000002B9E37DC EDUDriver__9sqzEDUObjFv + 0x19C 0x090000002B9E3AFC sqlzRunEDU__FPcUi + 0x3C 0x090000002B8E8F04 sqloEDUEntry + 0x6A4 </StackTrace> Cache space management will be invoked by the database manager only if the catalog cache heap has been exhausted, and new catalog cache entries need to be inserted. Thus, increasing theCATALOGCACHE_SZ database configuration parameter will help avoid this issue from occurring. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All. * **************************************************************** * PROBLEM DESCRIPTION: * * If an alter statement fails on a table containing dependent * * views, there is a small timing window which can cause the * * instance to trap if cache space management is running * * concurrently. * * * * The following stack can be used to identify this APAR: * * * * * * <StackTrace> * * -------Frame------ ------Function + Offset------ * * 0x090000002CEA318C * * sqlrlc_find_invalidate__FP8sqlrr_cbP10sqlrlc_keyUiP8SQLZ_RID * * + * * 0x84C * * 0x090000002CEC2180 * * sqlrlc_end_uow__FP8sqlrr_cbiP19sqlr_savepoint_info + 0x260 * * * * 0x090000002D7AE804 * * sqlrr_rbk_cleanup_mem__FP8sqlrr_cbiP19sqlr_savepoint_info + * * * * 0x104 * * 0x090000002D7AF030 * * sqlrr_stmt_rbk_svpt__FP8sqlrr_cbP19sqlr_savepoint_infoi + * * 0x290 * * 0x090000002D7BF8D4 sqlrr_sub_rrsvpt__FP8sqlrr_cbi + 0x14F4 * * * * 0x090000002CDBAF04 * * sqlrr_subagent_router__FP8sqeAgentP12SQLE_DB2RA_T + 0x17A4 * * * * 0x090000002CCEC268 sqleSubRequestRouter__FP8sqeAgentPUiT2 + * * * * 0xB28 * * 0x090000002CCF6F30 sqleProcessSubRequest__FP8sqeAgent + * * 0x190 * * 0x090000002B9F3AD0 RunEDU__8sqeAgentFv + 0x2F0 * * 0x090000002B9E37DC EDUDriver__9sqzEDUObjFv + 0x19C * * 0x090000002B9E3AFC sqlzRunEDU__FPcUi + 0x3C * * 0x090000002B8E8F04 sqloEDUEntry + 0x6A4 * * </StackTrace> * * * * Cache space management will be invoked by the database * * manager only if the catalog cache heap has been exhausted, * * and new catalog cache entries need to be inserted. Thus, * * increasing theCATALOGCACHE_SZ database configuration * * parameter will help avoid this issue from occurring. * **************************************************************** * RECOMMENDATION: * * Update to v97 fp1. * **************************************************************** | |
Local-Fix: | |
None. Increasing catalog cache size ( CATALOGCACHE_SZ database configuration ) might help to reduce the occurrences of trap. | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows | |
Lösung | |
The problem has been fixed in v97 fp1. | |
Workaround | |
None. Increasing catalog cache size ( CATALOGCACHE_SZ database configuration ) might help to reduce the occurrences of trap. | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 22.10.2009 04.01.2010 04.01.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP1 | |
Problem behoben lt. FixList in der Version | |
9.7.0.1 |