Monthly Archives: April 2009

UCF & Oracle Database Tuning Guide (for DCTM)

Check out the documents here.


Best Practices: Fulltext HA Deployment

Check out the document here. Its a PDF.


How to remote terminal services (correctly)

Typically we would just use the remote desktop icon to remote into a server, or for the more command-line driven folks, a /mstsc at the run command prompt. I was told by tech support to actually use the following for windows server instead: /mstsc /console /v:[servername]

I don’t quite understand why, but it seems to have something to do with 1 single account. Please let me know if you’ve the exact explanation(s). No prize though.


How to get a long list of r_object_id into a file

  1. Remote into the content server machine
  2. Create a file called objects.api on c:\temp (or any directory you like); the file content shall be:
    • #get all r_object_ids for dm_document type
    • ?,c,select r_object_id from dm_document
  3. Then run the DOS command on content server
  4. iapi32 -U -P c:\ids.txt
  5. It will store all r_object_ids in the ids.txt.

How to submit a list of objects for indexing

Instead of using the API to send the objects for indexing, one-by-one, there is a simpler and more efficient way of doing things.

  1. Generate the list of r_object_id by this DQL:
    • select r_object_id from dm_document
  2. Copy the list into a TXT file (filename: ids.txt)
  3. Save the TXT file @ :\Documentum\jboss4.2.0\server\DctmServer_IndexAgent1\deploy\IndexAgent1.war\WEB-INF\classes
  4. Once the resubmission is completed, the TXT file is renamed from: ids.txt >> ids.txt.done

Now, how do you actually get the list of r_object_id since the query potentially returns you millions of entries? Look out for the next post.


Useful Qeries: Determine failed to index objects

This DQL breaks down the failed items by type and user:

select name, task_state, count(*), item_type from dmi_queue_item where name in (‘dm_fulltext_index_user’, ‘dm_fulltext_index_user_01’) and task_state = ‘failed’ group by name, task_state, item_type order by name

You’ll need to modify the query accordingly for the “name” condition.


How to perform tracing for fulltext search

  1. Identify which content server the advance search will be sent to, e.g., server1
  2. Remote into the content server and launch iAPI
  3. Execute the following to turn on tracing:
  4. apply,c,NULL,MODIFY_TRACE,SUBSYSTEM,S,fulltext,VALUE,S,all
  5. Go to Webtop to perform the advance search
  6. Go back to the content server and execute the following API command:
  7. apply,c,NULL,MODIFY_TRACE,SUBSYSTEM,S,fulltext,VALUE,S,none
  8. Collect the log file @ W:\Documentum\dba\log\fulltext, filename is “fttrace_eRegistry.log”