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

ASSERT IN SQLRI_EXE.C WHEN BUFFERED INSERTS ARE COLLECTED BY AN ACTIVITIES
EVENT MONITOR.

Produkt:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problembeschreibung:
After doing : 
db2 "bind ~/sqllib/bnd/db2uimpm.bnd insert buf" 
the following command : 
db2 "import from /stage/tempo/$table.$schema.TXT of del insert 
into 
$schema.$table"  hangs. 
The application is shown as performing a close during the final 
commit phase. A force application does not work. The application 
has 
locks on tables SYSCOLUMNS and SYSTABLES, which prevent other 
operations on catalog. 
Customer has to stop the instance via TSA.
Problem-Zusammenfassung:
After doing : 
db2 "bind ~/sqllib/bnd/db2uimpm.bnd insert buf" 
the following command : 
db2 "import from /stage/tempo/$table.$schema.TXT of del insert 
into $schema.$table"  hangs. 
 
The application is shown as performing a close during the final 
commit phase. A force application does not work. The application 
has locks on tables SYSCOLUMNS and SYSTABLES, which prevent 
other operations on catalog. 
Customer has to stop the instance via TSA.
Local-Fix:
verfügbare FixPacks:
DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
First fixed in version 9.5 fixpak 5
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
21.10.2009
15.12.2009
15.12.2009
Problem behoben ab folgender Versionen (IBM BugInfos)
9.5.
Problem behoben lt. FixList in der Version
9.5.0.5 FixList