home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
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
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

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
DB2 Version 10.1 Fix Pack 6 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 FixList