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)
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/
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')
Create ACL
CREATE,c,dm_acl SET,c,l,object_name %NAME% SET,c,l,owner_name %repo_owner% SET,c,l,description This IS a ACL generated BY a script GRANT,c,l,dm_world,3
