Why Should We Create Separate Repositories in Documentum for Each Business?

In the world of enterprise content management, Documentum stands out as a robust platform for managing and storing vast amounts of content. When dealing with multiple business units or departments, one important architectural decision is whether to create a single repository for all content or to separate repositories for each business unit. Here, we’ll explore…

Read More

So What’s the GOLDEN FIX for Viewer Performance

Sometimes, you will notice this sql is taking over 34 sec instead of 0 sec. select all max(dm_document.r_modify_date) “maxdate” from dm_document_sp dm_document, dm_sysobject_r dm_sysobject_r2, dm_folder_rp dm_folder_r1 where (dm_document.r_object_id = dm_sysobject_r2.r_object_id and dm_sysobject_r2.i_folder_id = dm_folder_r1.r_object_id and dm_folder_r1.i_ancestor_id = ‘0b027183800008b3’) and (dm_document.i_has_folder = 1 and dm_document.i_is_deleted = 0) The original dql for this sql is: select max(r_modify_date)…

Read More

Why the Database is the First Thing to Check When Your Application Slows Down

In today’s fast-paced digital world, the performance of applications plays a crucial role in user experience and business operations. There are few things more frustrating than an application suddenly becoming slow, leading to a cascade of negative effects, from user dissatisfaction to lost revenue. When an application slows down, one of the most common culprits…

Read More

Documentum Server – SQL Server general performance best practices guidelines

Summary In Documentum Server, what are the general best practices guidelines for performance tuning of SQL Server databases? This issue was reported in (but may not be limited to): Documentum Server 7.0, 7.1, 7.2, 7.3, 16.4 Resolution Configurations on the SQL Server side Here are the recommended SQL Server configurations, according to our general performance…

Read More

What to Do When Content Loads Slowly

Run the following SQL query, and check how long it will take. This might be the root cause. This query is being called from xCP viewer: select all max(dm_document.r_modify_date) “maxdate” from dm_document_sp dm_document, dm_sysobject_r dm_sysobject_r2, dm_folder_rp dm_folder_r1 where (dm_document.r_object_id = dm_sysobject_r2.r_object_id and dm_sysobject_r2.i_folder_id = dm_folder_r1.r_object_id and dm_folder_r1.i_ancestor_id = ‘0b027183800008b3’) and (dm_document.i_has_folder = 1 and dm_document.i_is_deleted…

Read More

Webtop to D2 – journey

OpenText™ Documentum™ customers may experience issues with over-customization and extended use of the Webtop interface, a product they’ve relied on for 10-15 years. OpenText Documentum D2 offers a modern alternative, designed to enhance productivity and meet the needs of both casual and power users. Upgrading to D2 can provide a more streamlined, future-proof interface for…

Read More

Exploring the Diverse Industries Leveraging OpenText Documentum for Enterprise Content Management

OpenText Documentum is widely used by various organizations across different industries due to its robust enterprise content management capabilities. Notable industries and companies utilizing Documentum include: Documentum’s strong focus on security, compliance, and integration with other enterprise systems makes it an attractive choice for organizations with complex content management needs. However, it is often more…

Read More

Retention Policy Service in Documentum

In Documentum, a Retention Policy Service is a feature that helps organizations manage the lifecycle of their content by defining policies for retaining and eventually disposing of documents and other content items. This service is critical for ensuring compliance with legal, regulatory, and internal policy requirements. Key Features of Retention Policy Service in Documentum: Overall,…

Read More

Why Retention Policy is so important in Content Management?

Retention in content management is crucial for several key reasons: 1. Legal Compliance and Regulations Many industries are subject to strict regulations that dictate how long certain types of content must be retained. For example, financial records, medical documents, and legal contracts often have mandated retention periods to comply with laws like the Sarbanes-Oxley Act,…

Read More