Indexing fails with CTE0100 SQLSTATE=38C90 after updating the TEMPDIR of the fast indexer.

Technote (troubleshooting)


Problem(Abstract)

Sometimes even after updating the keyword tempdir in the emsutil.properties, DB2text update fails because it still looks into the old path and cannot find the expected files.

Symptom

You may see similar messages in the DB2 event table:

CTE0100 A DB2 operation failed. DB2 information: "38C90" "[IBM][CLI Driver][DB2/NT] SQL0443N  Routine "*ETCHFILE" (specific name "") has returned an error SQLSTATE with diagnostic text "Cannot open d:\temp\items\60\item.A1001001A08G12C15758I6070".  SQLSTATE=38C90



Resolving the problem

  • Check that the environment variable EMSUTIL_PATH points to the correct fast indexing directory. For example:
    • On Windows, fast indexing directory is
      C:\IBM\CSTextSearch\fastidx
      .
      Use this command to check :
      set %EMSUTIL_PATH%
    • On AIX, fast indexing directory is
      /opt/IBM/CSTextSearch/fastidx
      .
      Use this command to check:
      echo $EMSUTIL_PATH
  • If the path where EMSUTIL_PATH refers to is not correct:
    • Update the environment variable to point to the correct location.
    • Restart DB2.
  • In the emsutil.properties file found under EMSUTIL_PATH, ensure that the keyword tempdir has the correct value of the new temporary directory. For example:
    tempdir=e:\\temp\\items
  • If you have multiple fast indexing directories, ensure that INDEXDOCUMENTS found under EMSUTIL_PATH is being called.

Cross reference information
Segment Product Component Platform Version Edition
Enterprise Content Management CommonStore for Lotus Domino TextSearch AIX, Windows 2000 Server, Windows Server 2003 8.4
Enterprise Content Management Content Collector Content Collector for Email Windows 2003 server 2.1
Enterprise Content Management Content Collector Content Collector for File Systems Windows 2003 server 2.1

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

CommonStore for Exchange Server
TextSearch

Software version:

8.4

Operating system(s):

Windows 2000 Server, Windows Server 2003

Reference #:

1392289

Modified date:

2013-01-15

Translate my page

Machine Translation

Content navigation