DB2 - Problembeschreibung
Problem IC98954 | Status: Geschlossen |
Compiling a query can abend when a table in the query has CGS, and if RTS updates the table's statistics during compilation. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problembeschreibung: | |
DB2 can trap when compiling a query in the following situation. When Real Time Statistics (RTS) is enabled, and when a table involved in a query has out-of-date statistics, RTS can update the table's statistics during query compilation. If the table has any column group statistics (CGS), the query compilation can abend. The trap file can contain the following stack traceback at the top of the stack: -------Frame------ ------Function + Offset------ 0x0900000003AADFB0 __nw__9sqlnq_ftgFUl17sqlnq_storageTypeP3locRi+ 0x214 0x0900000003AAD1E0 populate_colgroup_stats_from_pd__9sqlnq_ftbFP3loc + 0x32C 0x09000000012C6AF4 need_statistics__9sqlnq_fcsFP3loc + 0x3A4 0x0900000003DF23E4 sqlno_ff_get_col_info__FP13sqlno_globals12SQLNO_COLTYPP11sqlno_t ablePP9sqlnq_qncP17sqlno_ff_qnc_infoPP9sqlnq_cstPfN37P13SQLNN_BO OLEANN211_ + 0x27C | |
Problem-Zusammenfassung: | |
DB2 can trap when compiling a query in the following situation. When Real Time Statistics (RTS) is enabled, and when a table involved in a query has out-of-date statistics, RTS can update the table's statistics during query compilation. If the table has any column group statistics (CGS), the query compilation can abend. The trap file can contain the following stack traceback at the top of the stack: -------Frame------ ------Function + Offset------ 0x0900000003AADFB0 __nw__9sqlnq_ftgFUl17sqlnq_storageTypeP3locRi+ 0x214 0x0900000003AAD1E0 populate_colgroup_stats_from_pd__9sqlnq_ftbFP3loc + 0x32C 0x09000000012C6AF4 need_statistics__9sqlnq_fcsFP3loc + 0x3A4 0x0900000003DF23E4 sqlno_ff_get_col_info__FP13sqlno_globals12SQLNO_COLTYPP11sqlno_t ablePP9sqlnq_qncP17sqlno_ff_qnc_infoPP9sqlnq_cstPfN37P13SQLNN_BO OLEANN211_ + 0x27C | |
Local-Fix: | |
Disable collection of real-time statistics by setting AUTO_STMT_STATS database configuration parameter to OFF. | |
verfügbare FixPacks: | |
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows | |
Lösung | |
First fixed in DB2 Cancun Release 10.5.0.4. | |
Workaround | |
Disable collection of real-time statistics by setting AUTO_STMT_STATS database configuration parameter to OFF. | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 23.01.2014 15.09.2014 15.09.2014 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.5.0.4 |