Audit Trails and Impact on Documentum Performance

-

Audit Trails and Impact on Documentum Performance
From my experience, we have to be careful about turning on audit trails in Documentum.  Turning on tracking for unnecessary events could lead to excessive audit trail creation in the database and will slow down the system.
For example, audit can be turned on for Sysobjects on several events. Two of these events are a bit confusing.
1) dm_getfile and 2) dm_fetch
While these two events sound similar at the first glance, their function is different.
1) dm_getfile occurs when a document is viewed or exported.  This is true “reading” of a document. You will want to turn this on to track which user downloaded/read this document.
2) dm_fetch occurs when webtop gets the documents attributes from the content-server.  This can occur when you perform a search or just browse to a folder.   This means that if you browse to a folder with 50 documents, it could potentially create 5o new audit trail records in the database!!  This is unnecessary, unless you have a strict security policy.
Watch out for this.  In our system, we turned on auditing for dm_fetch and ended up creating 8 million useless records and consuming all the database tablespaces.  After we realised what was happening, we turned off the auditing for dm_fetch and purged the unnecessary records, our system performance improved dramatically.
There are some excellent posts on EMC forums regarding this.  Do check them out.

Comments

Post a Comment

Popular posts from this blog

D2 Defination

-
                Contexts Contexts are used to define which configurations will be applicable for a given action based on the document properties and/or group membership. For example, you can create a context that applies for all dm_document content types created for quality assurance and set to the Draft status. Context is shown as the horizontal X-axis of the configuration matrix. D2 Dictionary A D2 Dictionary is a collection of key values and one or more sets of descriptive labels, used to provide value assistance to the end user. Dictionaries help end users by defining choice sets for property values, generating autonaming patterns, and providing input assistance during advanced searches. The choice sets ensure that uniform terminology is used across the context. D2 Taxonomy A D2 Taxonomy is a set of values in a tree hierarchy, driven by D2 Dictionaries. Taxonomy should be used if user wants t...
Read more

Documentum LSQM

-
  Documentum LSQM (Life Science Quality Management) is a software solution for managing and monitoring quality processes in the life sciences industry. It provides a centralized platform for managing and tracking documents, training records, and compliance information, as well as facilitating communication and collaboration among team members. LSQM helps life science companies ensure compliance with regulatory requirements and industry standards, such as 21 CFR Part 11 and GxP.
Read more

Documentum D2 Definitions

-
 D2 Definitions                 Contexts Contexts are used to define which configurations will be applicable for a given action based on the document properties and/or group membership. For example, you can create a context that applies for all dm_document content types created for quality assurance and set to the Draft status. Context is shown as the horizontal X-axis of the configuration matrix. D2 Dictionary A D2 Dictionary is a collection of key values and one or more sets of descriptive labels, used to provide value assistance to the end user. Dictionaries help end users by defining choice sets for property values, generating autonaming patterns, and providing input assistance during advanced searches. The choice sets ensure that uniform terminology is used across the context. D2 Taxonomy A D2 Taxonomy is a set of values in a tree hierarchy, driven by D2 Dictionaries. Taxonomy should be used if user wants to filter values or design a tre...
Read more