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

XML INPUT STORED PROCEDURE/UDF WITH PARAMETER MARKER AND REOPT ALWAYS
ENABLED CAN RETURN SQL0901N

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
The following error may be returned to an application calling a 
UDR or UDF : 
 
SQL0901N  The SQL statement failed because of a non-severe 
system error. Subsequent SQL statements can be processed. 
(Reason "QGM internal error: xpath does not have context qnc!".) 
SQLSTATE=58004 
 
This happens when REOPT ALWAYS was enabled when the procedure 
was created 
( via SYSPROC.SET_ROUTINE_OPTS('REOPT ALWAYS') ) and when one of 
the input parameters is of data type XML. 
 
There will be a trap file produced as well with the following 
callstack : 
 
sqloDumpEDU 
sqldDumpContext 
sqlrr_dump_ffdc 
sqlzeDumpFFDC 
sqlzeSqlCode 
sqlnn_erds 
sqlnq_xp_merge_xpaths 
sqlnr_merge_compute_boxes 
sqlnr_merge_and_create_mep 
sqlnr_xq_native_optprep 
sqlnr_optprep 
sqlnr_optprep_action 
sqlnr_comp 
sqlnr_seq 
sqlnr_rcc 
sqlnr_exe 
sqlnn_cmpl
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 970 fix pack 7                        * 
****************************************************************
Local-Fix:
Do not use REOPT ALWAYS for stored procedures that match the 
criteria of this apar. 
Recode the application to avoid using XML input parameters.
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 7 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 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
Problem has been fixed in DB2 version 970 fix pack 7
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC87862 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
15.05.2012
14.01.2013
14.01.2013
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.0
Problem behoben lt. FixList in der Version
9.7.0.7 FixList