|
Problem IC63954
|
Status: Closed |
Instance possibly traps if ALTER TABLE statement fails while catalog cache space management is running concurrently. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| 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. |
| Problem Summary: |
****************************************************************
* 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. |
| available fix packs: |
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
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. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 22.10.2009
04.01.2010
04.01.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP1
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.1
|
 |
