|
Problem IC65511
|
Status: Closed |
DB2 DESIGN ADVISOR (DB2ADVIS) MAY ABEND THE INSTANCE WHILE PERFORMING INDEX, MDC TABLE OR DPF PARTITIONING RECOMMENDATIONS |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 9.7 Fix Pack 2 or later. *
**************************************************************** |
| Local Fix: |
None exists (aside from not running db2advis). |
| available fix packs: |
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
|
| Solution |
First fixed in DB2 Version 9.7 Fix Pack 2. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 11.01.2010
31.05.2010
31.05.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP2
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.2
|
 |
