Documentum Sessions Query.

DQL Examples:
1) execute show_sessions
2) execute list_sessions
3) execute count_sessions

hot_list_size ->  No. of active content server sessions
warm_list_size -> Sessions that have been timed out on the server side
cold_list_size -> No. of free sessions.

Documentum DQL to select r_folder_path from r_object_id

You have to run a couple of DQL statements. Here are the steps:

1. select i_folder_id from dm_document where r_object_id = ‘myObjectId’
2. Retrieve the value returned, now known as myFolderID
3. select r_folder_path from dm_folder where r_object_id = ‘myFolderID’