|
Problem IC98949
|
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 / 970 - 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. |
| Solution |
First fixed in DB2 Version 9.7 Fixpack 10. |
| 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: IC98950 IC98951 IC98952
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 23.01.2014
18.12.2014
18.12.2014 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP10
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.10
|
 |
