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

DB2 MAY FAIL TO MOVE TABLE INTO NOT_SHARED STATE

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
DB2 pureScale server may fail to move a table into NOT_SHARED 
state for explicit hierarchical locking even there is only one 
member accessing that table. 
 
During the time of the problem, db2diag.log will continually 
show up error messages that db2ehl EDU gets interrupted when 
ever the table is accessed. Here is an example of the error 
messages: 
 
2015-01-01-01.01.01.000000+480 I53630300E567         LEVEL: 
Error 
PID     : 123456               TID : 6789  PROC : db2sysc 0 
INSTANCE: db2inst1             NODE : 000            DB   : 
SAMPLE 
APPHDL  : 0-12345              APPID: *N0.DB2.150101010101 
AUTHID  : DB2INST1             HOSTNAME: db2server 
EDUID   : 6789                 EDUNAME: db2ehl 0 (SAMPLE) 0 
FUNCTION: DB2 UDB, data management, sqldEHLPrepForPhaseOne, 
probe:897 
MESSAGE : ZRC=0x80020003=-2147352573=SQLB_INTRP "USER INTERRUPT 
DETECTED" 
          DIA8003C The interrupt  has been received. 
 
2015-01-01-01.01.01.000001+480 I53630868E1423        LEVEL: 
Error 
PID     : 123456               TID : 6789  PROC : db2sysc 0 
INSTANCE: db2inst1             NODE : 000            DB   : 
SAMPLE 
APPHDL  : 0-13526              APPID: *N0.DB2.150120081603 
AUTHID  : DB2INST1             HOSTNAME: db2server 
EDUID   : 6789                 EDUNAME: db2ehl 0 (SAMPLE) 0 
FUNCTION: DB2 UDB, data management, 
sqldEHLAttemptUpgradePhaseOne, probe:1545 
MESSAGE : ZRC=0x80020003=-2147352573=SQLB_INTRP "USER INTERRUPT 
DETECTED" 
          DIA8003C The interrupt  has been received.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* The user is running with EHL feature.                        * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to 10.5.0.6                                           * 
****************************************************************
Local-Fix:
Deactivate the database on the member where the table state 
shows incorrectly and access the table would move the table into 
correct state again.
Lösung
Problem Fixed In 10.5.0.6
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
29.01.2015
26.08.2015
26.08.2015
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.6 FixList