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

DB2 TERMINATES ABNORMALLY DURING EXPLAIN OF A CALL OR A QUERY CONTAINING AN
SQL FUNCTION REFERENCE

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
DB2 will terminate abnormally during explain of a CALL statement 
that satisfies all of the following conditions: 
 
    * The routine being called is an SQL procedure; 
    * The procedure contains one or more cursor declarations; 
    * The procedure has been previously invalidated, and has not 
been revalidated since. 
 
DB2 will also terminate abnormally when a query is being 
explained, and the query contains a reference to at least one 
compiled SQL function that satisfies the following conditions: 
 
    * The function contains one or more cursor declarations; 
    * The function has been previously invalidated, and has not 
been revalidated since.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* stored procedure users                                       * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 9.7 FP6 or higher                             * 
****************************************************************
Local-Fix:
As a workaround, you can force revalidation of procedures or 
functions before performing the activity that does the explain. 
The easiest way to do this is using the 
ADMIN_REVALIDATE_DB_OBJECTS procedure; e.g., 
 
db2 "connect to mydb" 
db2 "call sysproc.admin_revalidate_db_objects('PROCEDURE', NULL, 
NULL)" 
db2 "call sysproc.admin_revalidate_db_objects('MODULE', NULL, 
NULL)" 
db2 "call sysproc.admin_revalidate_db_objects('FUNCTION', NULL, 
NULL)" 
 
which will revalidate all procedures, module routines, and 
functions in the connected database.
verfügbare FixPacks:
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 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 fixed in DB2 Version 9.7 Fix Pack 6 and subsequent fix 
packs.
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC84402 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
14.10.2011
28.06.2012
28.06.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP6
Problem behoben lt. FixList in der Version
9.7.0.6 FixList