HowTo reset a Repository owner system user

1. Stop the Documentum Content Server (Repository) and DocBrocker
2. Go to $DM_HOME/dba/config/<repository name>/ 
3. Backup dbpasswd.txt 
4. Run SQL command in DBMS (change the password of Repository Owner)
 ALTER USER <Repository Owner Username> IDENTIFIED BY <New Password>; 
5. Replace the new password as plain text (<New Password>) in dbpasswd.txt  and save it
6. Go to $DM_HOME/product/6.7/bin/ and run the following: 
dm_encrypt_password -docbase <docbase name> -rdbms -encrypt <database password> 
7. Run Repository and DocBrocker start scripts. 

Troubleshooting. Checklist.

Troubleshooting

1)     Analize all DCTM log files (DocBrocker / Docbase / WebApp)

2)     Check RAM memory (command: topas) and storage free space, free inode on server (commands df, du)

3)     Restart App (Save all log and stop app / clear cache / start app )

4)     Check system jobs log and ensure that jobs are active and there are no critical warnings in logs (especially DMDbWarning – assess a free space and extents of DB / consider index creating)

1. DMClean job -  removes deleted and orphaned objects from the Docbase.

2. DMFileScan job removes deleted and orphaned content files from the file system.

3. Log Purge job removes server and session logs from the Docbase and file system.

4. Consistency Checker job runs 77 referential integrity checks on the Docbase.

5 Update Stats job updates database table statistics and repairs fragmented tables

6. QueueMgt job deletes dequeued Inbox items from the Docbase.

7. State of the Docbase job produces a report of the repository environment and statistics about object types.

5)     Check quantity of dm_audittrails (DCTM user activity log records), dmi_queue_item (BP tasks records) – delete unneeded records if too many quantity

*********************************************************************************

ACTIONS AFTER UPDATES and RECONFIGURATION

If you updated something objects in repository, please perform cleaning cache and reinitilisation of Repository

publish_dd,c (flush entire cache)

publish_dd,c,,dm_document (flush cache for dm_document type, there is extra comma after c for the locale)

reinit,c

If services DCTM hasn’t been started – check conf env

/etc/services  - docbrocker and repository ports shout be defined

/ect/hosts – host and IP address resolution shout be defined

Useful unix command (AIX OS)

How to assess a volume of directories and files in certain directory

 du -ms <PATH_TO_DIR>/* | sort -rnk 1 [ | head -N ]

For example

 du -gs /websphere/AppServer/profiles/AppSrv01/*  | sort -rnk 1

WDK-based application architectural stack (Documentum 6.7) from official WDK manual

How to bring your personal code to Documentum software

/* under construction */ 1) Create your class with needed methods 2) In application xml file define a new java class 3) In Forms Builder define as action the custom action (method from class)

What do you need for start development or support the EMC Documentum

This presentation on slideshare helps you to start understand Documentum (DCTM) principles quickly: Introduction to Documentum

In most cases Documentum set up to Linux/Unix environment - RHEL/AIX distributives (though Windows version of DCTM is included), so you need to be experiencied in *nix command.

If you are developer, in a nutshell, you are doing the next points

1) For files (content) processing - write methods (classes) for Java Method Server

2) For GUI - customize java web-applications (Taskspase or Webtop)