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

RETURN OF SQL0083C MAY CAUSE A HANG in an SMP environment.

Produkt:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problembeschreibung:
Having SQL0083C returned may result in a hang of the database. 
This is only in a SMP env. (INTRA_PARALLEL YES) 
 
Stack: 
IntrptWaitLock 
sqlri_hsjnInit 
 
For example: 
 
insert into t.t4 select c.c1, c.c2 from t.t3 c, ( select b.c1, 
b.c2 from t.t1 a, t.t2 b where a.c1=b.c1 ) d where c.c2=d.c2 
 
DB21034E  The command was processed as an SQL statement because 
it was not a 
valid Command Line Processor command.  During SQL processing it 
returned: 
SQL0083C  A memory allocation error has occurred.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* SMP                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Install this fix.                                            * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows

Lösung
See Error Description. Install this fix.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
03.06.2013
04.11.2013
04.11.2013
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.1.0.3 FixList
10.1.0.3 FixList