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 IC62993 Status: Geschlossen

QUERY MAY RETURN SQL0901 ERROR WITH SQLNO_ITR_PLAN::NEXT MESSAGE IN THE
DB2DIAG.LOG

Produkt:
DB2 FOR LUW / DB2FORLUW / 910 - DB2
Problembeschreibung:
A query may return an SQL0901 error in certain circumstances. 
The associated error in the db2diag.log indicates that during 
planning, all available access plans were pruned and there was 
no remaining plan. 
 
 
2009-07-21-12.59.44.867308-300 I1329601A745   LEVEL: Severe 
PID : 1810706        TID  : 1    PROC : 
db2agent (SAMPLE) 0 
INSTANCE: db2insti        NODE : 000   DB   : SAMPLE 
APPHDL : 0-1527        APPID: 
GA0AC828.OD11.06E8C1175927DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 
136 bytes       sqlcaid : SQLCA  sqlcabc: 136 
sqlcode: -901 sqlerrml: 58 sqlerrmc: sqlno_itr_plan::next 
[300]:rc(     0)     sqlerrp : SQLNO08E 
      sqlerrd : (1) 0x00000000  (2) 
0x00000000 (3)      0x00000000 
           (4) 0x00000000    (5) 
0xFFFFFED4 (6)      0x00000000 
        sqlwarn : (1) (2)  (3) 
 (4)     (5)       (6)       (7)      (8) (9) 
(10)     (11)    sqlstate: 
 
 
 
        The stack associated with the error may 
include: 
     sqlnn_erds 
     sqlno_itr_plan::next 
     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_walk_qun 
     sqlno_each_opr 
     sqlno_top_qtb 
     sqlno_each_qur 
     sqlno_scan_qgm 
     sqlno_planning_scan 
     sqlno_planning_phase 
     sqlno_exe
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* A query may return an SQL0901 error in                       * 
* certaincircumstances.The associated error in the db2diag.log * 
* indicates thatduringplanning, all available access plans     * 
* were pruned and therewasno remaining                         * 
* plan.2009-07-21-12.59.44.867308-300 I1329601A745  LEVEL:     * 
* SeverePID : 1810706        TID  : 1    PROC :db2agent        * 
* (SAMPLE) 0INSTANCE: db2insti        NODE : 000  DB  :        * 
* SAMPLEAPPHDL : 0-1527                                        * 
* APPID:GA0AC828.OD11.06E8C1175927DATA #1 :                    * 
* SQLCA,PD_DB2_TYPE_SQLCA,136 bytes      sqlcaid : SQLCA       * 
* sqlcabc: 136sqlcode: -901 sqlerrml: 58 sqlerrmc:             * 
* sqlno_itr_plan::next[300]:rc(    0)    sqlerrp :             * 
* SQLNO08Esqlerrd : (1) 0x00000000  (2)0x00000000 (3)          * 
* 0x00000000(4) 0x00000000    (5)0xFFFFFED4 (6)                * 
* 0x00000000sqlwarn : (1) (2)  (3)(4)    (5)      (6)      (7) * 
*      (8) (9)(10)    (11)    sqlstate:The stack associated    * 
* with the error                                               * 
* mayinclude:sqlnn_erdssqlno_itr_plan::nextsqlno_crule_nljnsqlno 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Version 9.1 Fix Pack 9.                           * 
****************************************************************
Local-Fix:
Setting the following registry variable may avoid the error: 
db2set DB2_REDUCED_OPTIMIZATION=ON
verfügbare FixPacks:
DB2 Version 9.1 Fix Pack 9  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows

Lösung
Problem was first fixed in Version 9.1 Fix Pack 9.
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC63086 IC63091 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
04.09.2009
22.04.2010
22.04.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
9.1.FP9
Problem behoben lt. FixList in der Version
9.1.0.9 FixList