Here are some real great tips that I have found. Please post any tips that you think may be useful. If you have the source, please post that as well.
- The Mandatory Access Control List feature introduced in 5.3 may cause performance issues, if a user is part of a lot of groups. The SQL generated from this can be significantly inefficient. There is a macl_security_disabled setting in dm_docbase_config object. By setting it to TRUE, the MACL security features are disabled and the inefficient part of the SQL is elimated. If you do not plan to use MACL, this is one way to improve performance. Source: Support Forums.


2. Improve Performance of FAST by an order of magnitude
Until DCTM gets FAST documented properly, many of us are walking around in the dark with respect to how it can be tuned for performance. This note on the forums gives you some tips.
Source: Support Forums
http://forums.emc.com/nsepn/webapps/xpsgggfs31465mnldcpq14543562/forums/thread.jspa?threadID=43793
3. Crypto Objects initialization error
If you have cloned or migrated a Docbase you may have had to deal with the AEK key problem, here are the steps necessary to fix your install.
Source: Suport Forums
https://forums.emc.com/nsepn/webapps/xpsgggfs31465mnldcpq14543562/forums/thread.jspa?threadID=39872
Virtual Documents Explained
Dirk van der Walt wrote a little article in this support post that does a great job of explaining the data model and concepts around virtual documents. This is the best summarization I’ve seen.
Source: Support Forums
https://forums.emc.com/nsepn/webapps/xpsgggfs31465mnldcpq14543562/forums/thread.jspa?threadID=28166
Joerg Krause, identifies using UNION instead of OR with FOLDER predicate increases performance significantly in MSSQL:
Source: Support Forums:
https://forums.emc.com/nsepn/webapps/xpsgggfs31465mnldcpq14543562/forums/thread.jspa?threadID=47087
In one situation, I have to decide what query to execute dynamically and secondly based on result from first query, if nothing is in collection, need to move on with next priority query.
This is going to be implemented in GetNextTask functioanlity where I need to decide which task shuld be pulled without depending on policy priority.
So question is, how it’s OK from performance point of view, if I write a stored procedure and entire logic will be build in store procedure rather than handling it at helper class level in WDK framework?
Paul Carter of EMC wrote an incredible little explanation of UCF internals and the INITGAIRConnector
https://forums.emc.com/nsepn/webapps/xpsgggfs31465mnldcpq14543562/forums/thread.jspa?threadID=58246#471061
Jhonny,
Can you please explain me proceduere or how to integrate Documentum 5.3 sp3 to M.S Share point Portal… or please let me know some manuals…
Have you looked at Content Services for Sharepoint? http://software.emc.com/products/software_az/content_services_for_sharepoint.htm?hlnav=T
Hi Johny,
If the search is done with single attribute is case-insensitive and if the search is done with multiple attributes in advanced search,the search is case sensitive. please let us know whether the search case is sensitive or case-insensitive in .
We are using Documentum 5.3 sp5.and configured the fulltext index server.
Thanks in advance..
Nagesh
We are working on Documentum 5.3 for 2d Autocad drawings and PDMWorks for 3D Solid works drawing.
3d drawing from PDMWork are coverted in to 2d drawing and loaded in documentum.
Users face problem in documentum, When they work simultaneously on PDMWork and Documentum. They encounter this explorer error which close both documentum and PDMWorks. I have attached the screen shot.
Have you seen this kind of problem earlier. Can you please guide me in this.