|
Problem IC98954
|
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 / A50 - 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 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
|
| Solution |
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. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 23.01.2014
15.09.2014
15.09.2014 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.4
|
 |
