DB2: How to get active user connections thro SQL query?

I have a VB application which uses DB2 as back-end. I want to limit the users
of my application to say 50.

Is there any way of writing SQL query to get active users of this VB application?
I know how to do this in MSSQL server and Oracle. I need help in DB2.

I'll appreciate any help.

"mark" <mnuttall@nospam.com> wrote:
>
>use 'list applications' - although you have to have the proper security
to
>run it.
>
>"Vinay" <vinay@gallerysystems.com> wrote:
>>
>>Hi,
>>
>>I am new to DB2 and I want to know whether in DB2 it's possible to get
active
>>user connections thro' a SQL query.
>>
>>I'll appreciate any help!
>

Query is like this (for Oracle) :

SELECT COUNT(COUNT(UserName)) Num FROM v$session WHERE UPPER(UserName) =
'DBO' GROUP BY MACHINE

"Stephen" <mcmillas@mfish.govt.nz> wrote:
>
>I am using Oracle & VB and would like to know how you do it!
>
>Can you please post your method
>
>Thanks
>
>
>"Vinay" <vinay@gallerysystems.com> wrote:
>>
>>I have a VB application which uses DB2 as back-end. I want to limit the
>users
>>of my application to say 50.
>>
>>Is there any way of writing SQL query to get active users of this VB application?
>>I know how to do this in MSSQL server and Oracle. I need help in DB2.
>>
>>I'll appreciate any help.
>
>