DB2 - Problembeschreibung
Problem IC62645 | Status: Geschlossen |
WHEN FABRICATING STATS FOR A TABLE WHICH HAS NOT HAD RUNSTATS PERFORMED ON IT, DB2 MAY TRAP | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
When fabricating stats for a table which has not previously had runstats run on it db2 can trap during that process with the following stack. <StackTrace> -------Frame------ ------Function + Offset------ 0x090000001177A1F4 populate_from_pd__9sqlnq_ftbFP8sqlrg_pdP11sqlrrst 0x09000000110FB998 sqlnq_cat_look2__FP20sqlnq_multipart_namePP9sqlnq 0x09000000111E5640 sqlnq_cat_look__FP20sqlnq_multipart_namePP9sqlnq_ 0x09000000111E59C0 sqlnq_handle_qtb_extref_rec__F20sqlnq_multipart_n 0x09000000111E57D4 sqlnq_handle_qtb_extref_rec__F20sqlnq_multipart_n 0x0900000010E7D5C0 @106@sqlnq_handle_named_ref__F20sqlnq_multipart_n 0x0900000010E7D3E8 @106@sqlnq_handle_named_ref__F20sqlnq_multipart_n 0x0900000010E7D3E8 @106@sqlnq_handle_named_ref__F20sqlnq_multipart_n 0x0900000010E7D834 sqlnq_handle_named_ref_in_src__FP12sqlnq_stringiP 0x09000000117314D8 sqlnq_handle_table_ref__FP20sqlnq_multipart_nameP 0x0900000011731008 sqlnq_handle_from_table_ref__FP20sqlnq_multipart_ 0x090000001110D4BC sqlnq_handle_from_table_ref__FP20sqlnq_multipart_ 0x090000001110D3B0 sqlnq_sem__FPP8stknode_i10actiontypePUcP3loc + 0x 0x09000000111107E4 sqlnp_parser__FP8sqlnp_cb - 0x8C 0x0900000011110BA8 sqlnp_parser__FP8sqlnp_cb + 0x338 0x090000001173445C sqlnp_main__FP12sqlnq_stringsPP9sqlnq_qur + 0x33C 0x090000001172E7A0 sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_com 0x090000001172DE80 sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_com 0x09000000116C048C sqlra_compile_var__FP8sqlrr_cbP14sqlra_cmpl_envPU 0x09000000116BE910 sqlra_find_var__FP8sqlrr_cbP17sqlra_cached_stmt13 0x0900000010DBB510 sqlra_get_var__FP8sqlrr_cbiT2bPbT5 + 0x440 0x0900000010391724 sqlrr_prepare__FP14db2UCinterfaceP16db2UCprepareI 0x0900000010458A08 sqljs_ddm_prpsqlstt__FP14db2UCinterfaceP13sqljDDM 0x090000001152DF24 sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDD 0x090000001152D500 .sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterface_f | |
Problem-Zusammenfassung: | |
Users affected: All users Problem Description: Db2 can trap while fabricating stats for a table. Problem Summary: See above | |
Local-Fix: | |
Performing runstats on the table may help to avoid this code path. | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows | |
Lösung | |
Problem was first fixed in Version 9.7 FixPak 2. | |
Workaround | |
Performing runstats on the table may avoid this code path | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 19.08.2009 01.07.2010 01.07.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7. | |
Problem behoben lt. FixList in der Version | |
9.7.0.2 |