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 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
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

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 FixList