Dqman initial load time
Does anyone know how to prevent dqman from loading the first 2000 groups, the first 5000 users, and every single cabinet at startup? With over 120,000 cabinets, it takes over 2 minutes just to start a session because of the above.
Comments
-
@DCTM_OT said:
dqMan is a fme tool and not documentum tool, though it helps in querying the Documentum docbase.I'm quite aware of this. While I appreciate you taking the time to comment, I don't see how it helps. I'm not even remotely the first one to post here about dqman as it's used quite universally given the lack of an "official" counterpart to same. For that matter, a number of OpenText folks use it (as indicated in various posts throughout the forum) and there's even a support note about it.
0 -
Well, FWIW, it appears that either some things cached or setting some options (like hiding private cabinets) has significantly improved the session start time.
0 -
Hi there,
the session startup queries are stored in the (dqMan home)\config\dqManDQLHelp.xml file.
You can edit the queries in the <queries> section:
<queries>
<query id="dm_type">select distinct name from dm_type order by name</query>
<query id="dm_registered">SELECT distinct object_name from dm_registered WHERE object_name NOT like '%_s' ESCAPE '\' and object_name NOT like '%_r' ESCAPE '\' ORDER BY object_name</query>
<query id="dm_group">select distinct group_name from dm_group order by group_name enable(RETURN_TOP 2000)</query>
<query id="dm_user">select distinct user_name from dm_user WHERE r_is_group=0 ORDER BY user_name enable(RETURN_TOP 5000)</query>
<query from="6.0" id="dmc_aspect_type">select distinct object_name from dmc_aspect_type ORDER BY 1 enable(RETURN_TOP 5000) </query>
</queries>If you remove a query please check where it is referenced (by ID) in the <dynamic> section of the same XML. Maybe, you Need to remove the referncing value assistance.
2
Categories
- All Categories
- 107 Developer Announcements
- 53 Articles
- 104 General Questions
- 141 IM Services
- 43 OpenText Hackathon
- 32 Developer Tools
- 20.6K Analytics
- 4.1K AppWorks
- 8.9K Extended ECM
- 898 Cloud Fax and Notifications
- 76 Digital Asset Management
- 9.3K Documentum
- 29 eDOCS
- 118 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management