DQL Hints – Part 1

Posted by Sumeet on Oct 29, 2007 in Documentum

DQL hints are handled differently by different RDBMS. Hence,

* Measure performance before and after using the hint.
* Turn on SQL tracing on the server. This will write the underlying SQL queries to the trace log which may then enable you to debug problems.
* Check “Show the SQL” in the DQL utility. This will also help you view the underlying SQL queries
Read more…


What’s my Full Text Index Size??

Posted by Sumeet on Oct 24, 2007 in Documentum

The attached fixml sizing program can be used to estimate the size of a Fulltext Index. Please only use this program in conjunction with the Sizing Documentum 5.3 Full Text white paper available on Powerlink.

Step #1: Suspend FAST indexing

rtsadmin localhost 16099 webcluster 0 0 suspendindexing
Read more…


Custom Obj Type * Templates

Posted by Sumeet on Oct 14, 2007 in Documentum

OK you’ve created a custom object type, now its time to load it with templates!

The simple and quick way to do would be creating a new folder , lets say ‘<custom-obj-type>_template’ , under the cabinet ‘Templates’. You can either copy the objects you wish under /Templates and place them into the new folder you created, or you may do it for all objects via the ‘Add to Clipboard’. You can choose whichever way you’re comfortable.
Read more…



Posted by Sumeet on Oct 7, 2007 in Documentum

IAPI should not be used to create LDAP config objects. LDAP config objects need to be created using Documentum Administrator (DA) due to the following reasons:

1. DA creates the LDAP password file in the file system which is needed to bind to the LDAP server

2. DA runs the LDAP validation class and makes sure that the attributes entered are valid.
Read more…


When to use External Pwd Chk in LDAP config

Posted by Sumeet on Oct 6, 2007 in Documentum

The following is a list of options for the user authentication options in Content Server (CS) :

1. OS Authentication mode

2. LDAP Authentication mode

3. OS-integrated LADP Authenticated mode
Read more…


DCTM Admin ‘Best Practices’

Posted by Sumeet on Oct 1, 2007 in Documentum

1. API collections are used to loop through a set of object instances. While the collections are open, database cursors are open and thus locks are held in the database. Therefore, do not keep the collections open longer than necessary so that the cursors and locks will be released. Do not perform any extraneous operations within a collection that could be performed after or before the collection is opened. Consider retrieving and storing attributes being returned in a collection in local variables or an array first, and then processing them later in order to close the collection earlier. For example, an application may retrieve attributes within a collection and perform a “getfile” API (which could have a sizeable impact on elapsed time due to the transfer of the content) within the collection. It is best to store the attributes necessary to do the “getfile” in a local array, close the collection and then perform the “getfiles” afterwards, releasing the locks on the database.
Read more…

Copyright © 2021 dm_maniacs All rights reserved. Theme by Laptop Geek.

wordpress stats