number of connected users

[M-HT]

Hallo,
is it possible to find out the number of connected users to a DB from within a program?

 

[istvan.hollo]

Roman,

Please try the next:

FIND FIRST _License NO-LOCK NO-ERROR.
DISPLAY
_License._Lic-Id
_License._Lic-ActiveConns
_License._Lic-CurrConns
WITH 1 COL 1 DOWN
.

If you have more than one database you have to use the DB prefix. In _License file is some other informations also.

Regards,
Istvan

 

[M-HT]

Hi Istvan,
thanks for the tip, but there is no such table in the DB (maybe wrong version - 8.2B).
Is there another way to find it out?

 

[rob bradford]

Check if your database has VST's enabled.

I'm running 8.3b and the sample code works against the databases I have - but they do have VST's enabled.

 

[M-HT]

So I enabled the VST's and it's working now. Thanks guys.
Just two questions though:
What's the difference between active and current connections (or more precisely which one is which)? and
How does batch connections count to it (is it contained in one of the former or is it counted separately)?