How do I count the number of open Documentum sessions?

Derrick

I'm trying to find a way to count the number of DFC sessions I have open at any given time.

Is there a way I can do this without logging into a WDK client, like DAM or DA?  For example, is there a database table in MS SQL Server holds the session information so I can query it to determine the number of open sessions?

Or is there a way I can write a program to do this?  I tried to get my hands on Xense but found it doesn't support D6.5 yet, and I need to check on both D6.5 and D5.3...

DCTM_Guru

This information is not persisted in the database tables.  You can using this DQL function to lookup this runtime information:

execute show_sessions; OR

execute list_sessions;

You will have to write a DFC app to execute the DQL.

DCTM_Guru

This information is not persisted in the database tables.  You can using this DQL function to lookup this runtime information:

execute show_sessions; OR

execute list_sessions;

You will have to write a DFC app to execute the DQL.

msroth

You can also run the dm_who.awk script in the /bin directory.

     dmawk32 -f dm_who.awk <docbase> -U<username> -P<password>

It will give you output like this:

Current users on docbase 'Docbase'

User            Connected From  Start Time            Last Activity         Session ID
~~~~            ~~~~~~~~~~~~~~  ~~~~~~~~~~            ~~~~~~~~~~~~~         ~~~~~~~~~~
dmadmin         <host>          10/14/2009 9:14:43 P  10/14/2009 9:14:43 P  0100218d80004121
dmadmin         <host>          10/14/2009 8:55:32 P  10/14/2009 9:14:36 P  0100218d80004103
dmadmin         <host>          10/14/2009 9:02:45 P  10/14/2009 9:04:27 P  0100218d80004113
dmadmin         <host>          10/14/2009 9:01:26 P  10/14/2009 9:02:31 P  0100218d80004110
dmadmin         <host>          10/14/2009 8:58:53 P  10/14/2009 8:58:59 P  0100218d8000410b
dmadmin         <host>          10/14/2009 8:56:53 P  10/14/2009 8:56:59 P  0100218d80004107
dmc_wdk_preset  <host>          10/14/2009 8:54:47 P  10/14/2009 8:54:48 P  0100218d80004101
dmc_wdk_prefer  <host>          10/14/2009 8:54:25 P  10/14/2009 8:54:45 P  0100218d80004100

mgrootsch

Execute with iapi32.exe

  apply,c,NULL,LIST_SESSIONS
   next,c,q0
   dump,c,q0

silvrlifeA0

Works well.

Thanks for sharing

Apart from above I use exec show_sessions in dql( which gives same result)

If I simply want the count, I use exec count_sessions.

This is for the content server.