IO10879: Receiving "SQL1131N DARI (Stored Procedure) process has been terminated abnormally" when enabling text search for an itemtype

APAR status

• Closed as program error.

Error description

• Customer received the 1131 error while enabling text search at
  item type def.
  
  The root cause is fenceid does not have permission to create
  file under /%IBMCMROOT%/cmgmt/ls/icmnlsdb.
  
  workaround is to correct the permission for
  /%IBMCMROOT%/cmgmt/ls/icmnlsdb.
  

Local fix

• workaround is to correct the permission for
  /%IBMCMROOT%/cmgmt/ls/icmnlsdb.
  

Problem summary

• If the DB2 fence ID does not have permission to create files in
  the %IBMCMROOT%/cmgmt/ls/icmnlsdb directory, the creation of an
  item type with text search enabled will fail  fails and the
  following error messages will be are logged in the dklog log
  file:
  
  [EXC]: 06/09/2009 at 13:49:54.828 GMT @ dpape (9.26.25.95);
  com.ibm.mm.sdk.common.DKException #
  com.ibm.mm.sdk.logtool.DKLogManager_Log4J
  [USR]: dpape (C:\Documents and Settings\Administrator)
  @ C:\Program Files\IBM\II4C\db2cmv8\admin\common
  [THD]: AWT-EventQueue-0 ( 2ca42ca4 )
  [THG]: main = { TimerQueue, AWT-InputMethodManager,
  AWT-EventQueue-0,
  AWT-Shutdown, Java2D Disposer, AWT-Windows, Thread-1, Signal
  Dispatcher }
  [LOC]:
  com.ibm.mm.sdk.server.PItemTypeDefImpICM:defineComponentType
  [MSG]: DB2 SQL Error: SQLCODE=-1131, SQLSTATE=38503,
  SQLERRMC=-2097151964;*;*;*;*;;SEMAPHORE WAIT;, DRIVER=3.50.152
  at
  com.ibm.mm.sdk.server.PItemTypeDefImpICM.defineComponentType(
  PItemTypeDefImpICM.java:7514)
  

Problem conclusion

• This problem is fixed in DB2 Content Manager Version 8.3 Fix
  Pack 12. When DB2 fence ID does not have permission to create
  files in the %IBMCMROOT%/cmgmt/ls/icmnlsdb directory, the
  following error occurs:
  
  ICM7090: Cannot write Script or SQL file with the Defferred
  Generated DDL commands. Make sure the directory where the
  scripts are created has the correct permissions. The library
  server log file shows the name of the directory and additional
  information that might have been captured.
  (STATE): [LS RC=7090, SQL RC=13]
  

Temporary fix

• Change the ownership and permission for the
  %IBMCMROOT%/cmgmt/ls/icmnlsdb directory to ensure that the DB2
  fence ID can create files in this directory.
  

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  SYSTEM ADMIN

• Fixed component ID

  5724B1900

Applicable component levels