NA

Limit DQL results

The number of results from a DQL query can be limited by using the RETURN_TOP keyword. Since multiple rows can be returned for one object, the result limit does not always limit the results to a number of objects, but to a number of rows. The database does not know about 'Objects', therefore the result limit of returned objects is implemented in the content server. The database can only limit the result of rows. The way result limitation is executed is controlled by the 'return_results_row_based' parameter in the server.ini file : - return_results_row_based = False -> Returns Objects. - return_results_row_based = True -> Returns Rows. Default = True (Rows)

DQL Hint : enable(RETURN_TOP N)
Example : SELECT * FROM dm_document enable(RETURN_TOP 100) 

General workflow information

SELECT task_name, task_state, actual_start_date, dequeued_date FROM  
dmi_queue_item WHERE router_id = ‘workflowId’​
 
 

List of attachments for a specific workflow

SELECT r_component_id, r_component_name FROM dmi_wf_attachment WHERE  
r_workflow_id = '< workflow ID >'
 
 

Number of versions for a specific object

Object versions are related to each other by the i_chronicle_id attribute. The DQL counts the number of objects with the same i_chronicle_id. Any r_object_id of a document in the version tree can be used

SELECT count(r_object_id) FROM dm_sysobject (ALL) WHERE i_chronicle_id IN  
(SELECT i_chronicle_id FROM dm_sysobject WHERE r_object_id='< object id >'
 
 

List of failed authentication attempts (audit trail)

​SELECT * FROM dm_audittrail WHERE event_name='dm_logon_failure'​
 
 

Physical location of a file stored in the docbase

Files stored in Documentum are written to the content storage of the content server. To find the physical location of those objects on the disc, use the getpath command

DQL : Execute get_file_url FOR < object id >
API : getpath,c,< object id >
 
 

Submit object to indexing server

Send an object to the index queue

queue,c,,dm_fulltext_index_user,dm_save
 
 

Enable/Disable email notifications for all users

To disable mail notifications, edit/add the mail_notification property in the server.ini file. When the property is not available, the default behaviour will be 'True'

File : server.ini
mail_notification = False
 
 

Recover docbase owner password (db user)

The 'docbase owner' is used by Documentum to connect to the docbase. The password for this connection is stored in encrypted format at : $DOCUMENTUM/dba/config//dbpasswd.txt The password can be recovered by decrypting the stored password using IAPI (login as super user)

API>decrypttext,c,< encrypted password >
 
 

Qualify job to use in job sequence

Jobs can only be used in 'job sequences' when the method inplementation of the job has a value for the attribute 'success_return_codes'. The DQL will append the value '0' (since this is the code indicating successful execution) to the implementing dm_method of the job

update dm_method object append "success_return_codes" = 0 where object_name  
in (select method_name from dm_job where object_name='My Job')