DB2 - Problem description
Problem IC98953 | Status: Closed |
Compiling a query can abend when a table in the query has CGS, and if RTS updates the table's statistics during compilation. | |
product: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problem description: | |
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 Summary: | |
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. | |
available fix packs: | |
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows | |
Solution | |
First fixed in DB2 Version 10.1 Fix Pack 4 | |
Workaround | |
Disable collection of real-time statistics by setting AUTO_STMT_STATS database configuration parameter to OFF. | |
BUG-Tracking | |
forerunner : APAR is sysrouted TO one or more of the following: IC98954 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 23.01.2014 22.07.2014 22.07.2014 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) | |
10.1.0.4 |