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

INSTANCE CRASH IN FUNCTION SQLNG_BUILD_SET_OP DURING QUERY COMPILE.

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
This problem can only happen in v97 fixpack 1. 
 
If the instance is not configured for DPF (therefore, it is a 
single partition), and a query is compiled with the scrollable 
cursor attribute turned on (CLI attribute), and it is not an 
updateable scrollable cursor, then the compile of that query has 
a chance to trap and cause instance crash with the following at 
the top of the stack (see the stack traceback file): 
 
sqlng_build_SET_op 
sqlng_process_set_op
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Users affected: all                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* INSTANCE CRASH IN FUNCTION SQLNG_BUILD_SET_OP DURING         * 
* QUERYCOMPILE.                                                * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* apply v97 fp2                                                * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
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

Lösung
fix contained in v97 fp2
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
05.02.2010
12.07.2010
12.07.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP2
Problem behoben lt. FixList in der Version
9.7.0.2 FixList