|
Problem IC75129
|
Status: Geschlossen |
UNDER HIGH PARALLEL QUERY LOAD , NSE FAILS TO RELEASE FEW LOCKS WHICH CAN EVENTUALLY LEAD TO CTE0119 ERROR |
| Produkt: |
DB2 NET SEARCH / 5765F3800 / 910 - DB2 |
| Problembeschreibung: |
After installation of fixpack 9 customer experienced CTE0119
errors for several times. Each time he must stop and restart
NSE due to resolve the issue. He also increased maxLocksPerIdx
to 800 in db2extlm.cfg file. But the problem still happens.
CONTROL LIST ALL LOCKS ... almost never shows any locks. Only
sometimes LIST ALL LOCKS shows a S-lock. CONTROL LIST ALL LOCKS
shows also no locks even when cte0119 was thrown and each
search for the both indexes failed until stopping NSE (db2text
stop force). So he assumes that CONTROL CLEAR ALL LOCKS can not
resolve the problem too (because LIST can not see the locks). |
| Problem-Zusammenfassung: |
UNDER HIGH PARALLEL QUERY LOAD , NSE FAILS TO RELEASE FEW LOCKS
WHICH CAN EVENTUALLY LEAD TO CTE0119 ERROR |
| Local-Fix: |
Nonr |
| verfügbare FixPacks: |
DB2 Version 9.1 Fix Pack 11 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12 for Linux, UNIX and Windows
|
| Lösung |
Upgrade to V91fp11 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 22.03.2011
28.11.2011
28.11.2011 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.1.FP11
|
| Problem behoben lt. FixList in der Version |
| 9.1.0.11
|
 |
