home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 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 FixList