IBM Content Manager 8 – Data preparation constructor „ICMDCTOR“ is invalid

When you enable the DB2TS integration for IBM Content Manager 8 it could be that you receive the following erorr when you create a fulltext via Systemadmin Client.

ICMPLSCP defineTIEIndex                   02975 02/23 12:22:51.231 GMT ; 2026/02/23 13:22:51.231 LCT ; 17576 PID;23121840920442 1b:19c8a6ff919:X7f71 ICMADMIN CREATE INDEX failed
   sqlcode  -20427
   sqlerrmc <CIE00459E Data preparation constructor "ICMDCTOR" is invalid ".  SQLS >
   sqlerrp  <SQL11059>
ICMPLSCP ICMDEFINECOMPTYPE                01065 02/23 12:22:51.231 GMT ; 2026/02/23 13:22:51.231 LCT ; 17576 PID;23121840920442 1b:19c8a6ff919:X7f71 ICMADMIN Exit rc=7064 reason=0 extrc=-20427 extreason=0
ICMPLSLK quiesceServer                    04701 02/23 12:23:23.278 GMT ;23121840920442 1b:19c8a6ff919:X7f6f ICMADMIN Entry
ICMPLSLK quiesceServer                    05056 02/23 12:23:23.278 GMT ;23121840920442 1b:19c8a6ff919:X7f6f ICMADMIN Exit
ICMPLSLK ICMLISTNLSKEYWRD                 00189 02/23 12:23:23.278 GMT ;23121840920442 1b:19c8a6ff919:X7f6f ICMADMIN Entry
ICMPLSLK ICMLISTNLSKEYWRD                 00895 02/23 12:23:23.278 GMT ;23121840920442 1b:19c8a6ff919:X7f6f ICMADMIN Entry
ICMPLSLK ICMLISTNLSKEYWRD                 00958 02/23 12:23:23.278 GMT ;23121840920442 1b:19c8a6ff919:X7f6f ICMADMIN Exit return rc=0
ICMPLSLK ICMLISTNLSKEYWRD                 00220 02/23 12:23:23.278 GMT ;23121840920442 1b:19c8a6ff919:X7f6f ICMADMIN Input

To solve this you need to insert the following values into the SYSIBMTS.SYSTSDEFAULTS.

db2 "INSERT INTO SYSIBMTS.SYSTSDEFAULTS VALUES('DATAPREP:ICMDCTOR', '', 1)"