|
Problem IC74615
|
Status: Geschlossen |
DELETING ALL ROWS FROM TEXT INDEXED TABLE AND THEN RUNNING TEXT INDEX UPDATE OPERATION THROWS CTE0310 ERROR MESSAGE. |
| Produkt: |
DB2 NET SEARCH / 5765F3800 / 970 - DB2 |
| Problembeschreibung: |
The problem here is that , since all rows in base table is
deleted and then we update index, all index entires are
removed , so the .ded, .dei files are missing. And when these
files are not present, the disk space calculation is going
wrong. |
| Problem-Zusammenfassung: |
CTE0310 Error is thrwon when the indexed table is deleted of all
rows. Disk space calculation has been updated to consider empty
base table. |
| Local-Fix: |
Deleting all of the rows and then running update operation is
the same as dropping the text index. Customer should simply drop
the text index.
or
Customer could skip the update index operation after the - "db2
delete , db2 commit" operations , and continue with db2 import.
After import, Customer can then do a single update index, which
will take care updating the index of the deleted documents as
well as the newly imported rows. |
| verfügbare FixPacks: |
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 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Lösung |
Upgrade to V97fp5 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 23.02.2011
21.11.2011
21.11.2011 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP5
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.5
|
 |
