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

TEXT SEARCH INDEX UPDATE ERROR "CLI0129E,THERE ARE NO MORE HANDLES TO
ALLOCATE" WHEN INDEXING LARGE NUMBER OF DOCUMENTS

Produkt:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problembeschreibung:
db2ts "update index <index_name> for text" throws the below 
error message  in text search event view 
 
"CLI0129E,There are no more handles to allocate" 
 
when indexing large number of documents and using very small 
UPDATEAUTOCOMMIT (i.e. more commit cycles)
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 Text Search users who use UPDATEAUTOCOMMIT index         * 
* configuration option                                         * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V10.1 FP3 or later fixpacks                   * 
****************************************************************
Local-Fix:
Use Large value for  UPDATEAUTOCOMMIT
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
Fixed in DB2 V10.1 FP3
Workaround
Use large values for UPDATEAUTOCOMMIT  (i.e less commitcycles)
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC94311 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
22.07.2013
27.09.2013
27.09.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