Qtree | QTree ECM solutions

Snippets

Share your snippets!

Do you want to contribute and add your own snippets?
Start sharing your information here!
You don't have an account?
Create it here.

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')

Workflow Reporting indices

These DQLs will create indices on important columns to speed up workflow reporting

EXECUTE make_index WITH type_name='dmi_queue_item', attribute='stamp'
go
 
EXECUTE make_index WITH type_name='dm_workflow', attribute='process_id'
go

Creation of relations between roles, groups and users

DQL-script for the creation relations between roles, groups and users. An excel-sheet is available for the automated generation of these scripts. This sheet also contains (*) creation of users with a personal cabinet, (*) groups and roles, (*) creation of acl's (a code snippet already exists)

ALTER GROUP group_name ADD  
group_name_1,group_name_2,role_name_1,role_name_2,user_name_1,user_name_2;
go

Creation of users with a personal cabinet

DQL-script for the creation of users with a personal cabinet. An excel-sheet is available for the automated generation of these scripts. This sheet also contains (*) creation of roles / grous, (*) relations between groups, roles and users (= where composer fails!), (*) creation of acl's (a code snippet already exists)

CREATE dm_user OBJECT SET user_name='di_appl_beheerder_1', SET  
user_login_name='di_appl_beheerder_1', SET  
user_address='gert.stalmans@hp.com', SET user_privileges=16, SET  
client_capability=8, SET defa

creation of roles / groups

DQL-script for the creation of roles (drop the update-statements if you just want to create groups). An excel-sheet is available for the automated generation of these scripts. This sheet also contains (*) creation of users with a personal cabinet, (*) relations between groups, roles and users (= where composer fails!), (*) creation of acl's (a code snippet already exists)

CREATE GROUP di_administrators;
go
UPDATE dm_group OBJECT SET group_class = 'role' WHERE group_name =  
'di_administrators';
go