DB2 - Problembeschreibung
Problem IC64369 | Status: Geschlossen |
DB2 DESIGN ADVISOR (DB2ADVIS) MAY ABEND THE INSTANCE WHILE PERFORMING INDEX, MDC TABLE OR DPF PARTITIONING RECOMMENDATIONS | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
Problembeschreibung: | |
Instance may abend while running the DB2 Design Advisor (db2advis) in either of index, MDC table or DPF partitioning recommendation mode. The stack trace from such an abend may look something like: sqlno_get_best_key_cond sqlno_build_keycond sqlno_find_key_preds sqlno_btree_preds sqlno_index_scan sqlno_crule_index_scan sqlno_crule_access_root sqlno_crule_access sqlno_find_plan_chain sqlno_get_best_plan sqlno_crule_nljn_inner sqlno_crule_nljn sqlno_crule_join_choices sqlno_crule_join_order sqlno_crule_join_root sqlno_crule_join sqlno_gen_partitions_for_QTB sqlno_plan_end_opr sqlno_each_opr sqlno_walk_qun sqlno_each_opr sqlno_top_qtb sqlno_each_qur sqlno_scan_qgm sqlno_planning_scan sqlno_planning_phase sqlno_exe sqlno_exe sqlnn_cmpl ... | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description. * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 9.5 Fix Pack 6 or later. * **************************************************************** | |
Local-Fix: | |
None exists (aside from not running db2advis). | |
verfügbare FixPacks: | |
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows | |
Lösung | |
First fixed in DB2 Version 9.5 Fix Pack 6. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC65511 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 05.11.2009 14.06.2010 14.06.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.5.FP6 | |
Problem behoben lt. FixList in der Version |